SQL Server Agent Jobs support

Comments

• dnlnln Redgate › Posts: 234 Gold 2

  July 19, 2016 6:19AM

  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

  0 · Share on Twitter