Thursday, August 13, 2009

Management Studio : Script Multiple Jobs quickly

  1. Expand SQL Server Agent
  2. Click On 'Jobs'
  3. Click F7 (summary pane will appear on right)
  4. Highlight the jobs (Ctrl & Shift to select multiple)
  5. Right Click selected jobs
  6. Select 'Script Job as'
  7. Select script destination

No comments: