Post reply

SQL Agent Jobs in SSDT

  • July 26, 2012 at 5:54 am

    #261626

    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.

  • May 8, 2013 at 6:29 pm

    #1613583

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply