Saturday, November 12, 2016

How to script all SQLAgent jobs

Click the 'Jobs' folder under the SQL Server Agent node in SSMS, then hit the F7 key (brings up the Summary pane).  Highlight all the jobs you want to script using a combination of Shift and Ctrl keys, then right click, 

No comments:

Post a Comment