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.
| Author |
Topic |
|
chih
Posting Yak Master
154 Posts |
 Posted - 2007-08-21 : 21:05:20
|
| I plan to set up a standby server. It will require the same schedule jobs with the production server.Is there any way I can write a stored procedure to script schedule jobs to files?Thank you in advance |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-21 : 22:12:21
|
| You can copy jobs over with ssis task, or just script jobs in ssms by right clicking job and go to script job as -> create to -> file. |
 |
|
|
|
|
|
Script sql schedule agent job to a file