Tuesday, 12 October 2010

[SQL] Scripting out Jobs in SSMS

I found that you can script out all jobs from Management Studio.
  1. Open the server in the Object Explorer.
  2. Open the "Object Explorer Details" window.
  3. In the "Object Explorer Details" window, drill down to "SQL Server Agent"
  4. Drill down to "Jobs"
  5. Select the jobs you want to script.
  6. Right click and select "Script Job as", then "Create To", and select where you want them scripted to.
  7. Remember to filter out any "SSRS" jobs. (exclude any job name that contains a hyphen).

No comments:

Post a Comment