Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Agent Jobs in SSDT Expand / Collapse
Author
Message
Posted Thursday, July 26, 2012 5:54 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 27, 2014 8:03 AM
Points: 317, Visits: 1,079
I've got 2 SQL Agent jobs to deploy with a database, the whole lot being in a Sql Server Development Tools project. There is no dedicated Agent Job object, so I've scripted them in the post-deployment script using drop & re-create. (Obviously they're in msdb database.)

Is this the best way of doing it?

When you script the 'Schedule', the parameters differ between 2005/2008 so it is necessary to handle this issue in the script.
Post #1335718
Posted Wednesday, May 8, 2013 6:29 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, August 8, 2014 4:15 PM
Points: 727, Visits: 1,417
Current, there isn't a to do it outside of post-deployment scripts. The following article does provide a really nice walk through on how to handle it though:

http://blog.sqlconcepts.co.nz/2012/09/ssdt-sql-agent-job-deployment-template.html

Fraggle
Post #1450854
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse