Monday, September 26, 2011

Script ALL SQL JOBs from SQL Server Management Studio


How to script all the SQL Jobs from SQL Server Management studio?

Step 1: Go to SQL Server Mgmt Studio.
Step 2: Expand SQL Server Agent >> Jobs
Step 3: Hit F7 (or) goto menu View >> Summary
Step 4: Now ALL jobs would be listed out there.
Step 5: Make use of Control key and choose all the JOBs you want to script. (OR) If you want to script everything press Ctrl + A
Step 6: Right click >> "Script Job as" >> "Create To" >> File

Now you can make use of this file to create these jobs in your destination SQL Server Database.



11 comments:

Nisha said...

Nice Article !! Was very helpful..THanks a lot

Anonymous said...

Nice tutorial.
Server Management

Anonymous said...

Thanks a lot

Saifur said...

Very Handy. Thanks mate.

Peter said...

Saved me some time, thanks for that

Anonymous said...

Very nice pics, thanks!

Anonymous said...

Great!!!!

Thanks

Anonymous said...

That "F7" part was the thing that was missing from ALL the other posts on this subject. Thank you!!!

parimal said...

very helpful

Momcilo said...

Very helpful, many thanks!!!

Anonymous said...

Thanks a lot !