To script all jobs:
Step1: ‘Object Explorer Details’ from the View menu in SSMS, or press the F7 key.
Step2: Click on any job in the Object Explorer window and a list of all the agent jobs appears in the ‘Object Explorer Details’ window.
Select all the jobs you want to script (press the Ctrl button while clicking to select individual jobs) and then right click and select the scripting option you want.
This will then create all the selected jobs as a single query. You can script to a query window.
Step1: ‘Object Explorer Details’ from the View menu in SSMS, or press the F7 key.
Step2: Click on any job in the Object Explorer window and a list of all the agent jobs appears in the ‘Object Explorer Details’ window.
Select all the jobs you want to script (press the Ctrl button while clicking to select individual jobs) and then right click and select the scripting option you want.
This will then create all the selected jobs as a single query. You can script to a query window.
No comments:
Post a Comment