Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, August 19, 2016 7:38 AM
Points: 416, Visits: 1,247
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: Wednesday, August 10, 2016 2:17 PM
Points: 727, Visits: 1,500
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