Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Script for SQL server agent jobs

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2008-08-04 : 11:32:17
I created about 20 jobs in SQL server agent.
How to save them as scripts?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-04 : 12:54:03
click Jobs on SQL server agent.
choose view-summary-list(drop-down)-details . Select all jobs(Ctrl) and right click-script- This will script all jobs in SQL server 2005.
Go to Top of Page
   

- Advertisement -