Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions Links


SQL Server DBA Jobs

How do I save all SQL Agent Jobs

30 April,2024 by Tom Collins

Question: How can I export all the SQL Agent Jobs in one action , rather than saving each one individually .


Answer: It is possible to export all the SQL Agent Jobs into esay set of steps


1) Click on the “Jobs” section in the SQL Agent in SSMS and use the f7 keyboard key

2) You should now have the Object Explorer Details open lising all the SQL Agent Jobs

3) Highlight the SQL Agent Jobs  required for the  export . You can select all via Ctl A

4) Right-click the highlighted jobs and “Script Job As…” . save the file 

Author: Tom Collins (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on How do I save all SQL Agent Jobs | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer