Agent jobs
Would be great if SQL Server Agent jobs could be incorporated into SVN
Thank you everyone for your comments and votes on this over the years. While I don’t have a 100% full resolution for this suggestion, I can sum up our current recommendations here. Continued feedback is very welcome.
Our current recommendation is to use the post-deployment script feature of SQL Source Control (released in V6.3) to manage SQL Server Agent jobs.
An example script for this is here: https://documentation.red-gate.com/soc/common-tasks/working-with-pre-post-deployment-scripts/create-sql-server-agent-job
As some commenters in this thread have alluded to, it is possible (and sometimes very common) for SQL Agent jobs to have steps that touch multiple databases on a single SQL Server Instance. For this reason, some customers prefer to create a separate database for instance-level management and objects (sometimes named DBA or similar) and choose to manage things like linked servers and SQL Agent jobs with the post-script associated with that database.
This separate-database architecture also makes sense if the jobs are being deployed to an environment with an Availability Group. I wrote a bit more about this here under “SQL Agent jobs need special handling”: https://www.red-gate.com/simple-talk/blogs/database-devops-considerations-for-sql-server-availability-groups/
-
Tiago commented
I think in this tool is a must to have this control.
-
Rodrigo commented
Versioning jobs would definetely be an awesome feature.
-
Alexandre Corrêa commented
Very useful feature!
-
Barry H commented
A good idea - TFS
-
Rui Ferreira commented
would be a very nice and useful feature!
-
John H commented
Yes, please. SVN.
-
Daniele Barlocco commented
It would be greater if you could control in TFS not only the jobs, but also the DTSs and the maintenance plans.
-
Leslie P commented
I would like SQL Server jobs controlled under TFS. Ideally integrated into SSMS.
-
johndempsey commented
Would definitely like to see this feature in a future version.
-
Adam commented
and TFS, too please!
-
Bret Lowery commented
Ditto TFS