SQL Server Agent Jobs support
Is there a supported mechanism to script and/or deploy SQL Server Agent Jobs via ReadyRoll database projects?
Daniel Nolan
Product Manager
Redgate Software
Product Manager
Redgate Software
Comments
The process for setting up your SQL Agent jobs to deploy alongside your ReadyRoll project is as follows:
1. Use SQL Server Management Studio (SSMS) to script the jobs (right-click job, select Script Job as "DROP And CREATE to")
2. Save each job as a separate script file, e.g. overnight_processing.sql
3. Add the files to your ReadyRoll project to an Additional Scripts folder. More info on this here:
https://documentation.red-gate.com/disp ... al+Scripts
Additional Scripts behave similarly to Programmable Objects in that they deploy with each change to the script file. So if you need to make a change to the job, you can do so by editing the script file directly and deploying the project. Alternatively, you can make changes using the SSMS job properties dialog, then re-scripting the object and pasting the code back into the script file.
Product Manager
Redgate Software