camaro305hp - Monday, November 20, 2017 5:02 PM
Got it. Thanks for the feedback.
You do know that you can script out all of the jobs, correct?
1. In the Explorer Window of SSMS (press the {f8} key to get there if you don't know how), scroll down to the "SQL Agent Agent", expand it, the single click on JOBS.
2. Once that's done, press the {f7} key to open the Explorer Detail window. There, all of the jobs will be listed.
3. Select all of the jobs at once and then right click on the selection. Select "Script Job As" and then follow your nose. All the selected jobs will be scripted to the destination you chose and that includes the schedules and everything else.
--Jeff Moden
Change is inevitable... Change for the better is not.