SQL Server Agent Jobs support

dnlnlndnlnln Posts: 234 Gold 2
edited July 19, 2016 6:19AM in ReadyRoll
Is there a supported mechanism to script and/or deploy SQL Server Agent Jobs via ReadyRoll database projects?
Daniel Nolan
Product Manager
Redgate Software

Comments

  • ReadyRoll doesn't currently have any way to automatically sync agent jobs, however you can script it yourself and include it within your RR project.

    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.
    Daniel Nolan
    Product Manager
    Redgate Software
Sign In or Register to comment.