Monday, March 18, 2013

How to create scripts for all /selected SQL Server Agent Jobs?

SQL Server may have many jobs and if you have a requirement of scripting them, if you are using object explorer you cannot scripting them all at once as shown in the below screen.

image

Go to View -> select Object Explorer Details, you will be taken to following screen.

image

From then above list either you can select all the jobs or jobs you need to script. Then you can create script as shown in the below screen.

image

No comments:

Post a Comment