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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-02-07 : 15:04:30
|
| Hi,How to script a schedule in sql sever agent. I did not see any option there.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-07 : 15:12:19
|
| use msdb.dbo.sp_add_jobschedule for creating schedules------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-07 : 16:31:27
|
| If you mean to generate the script for an existing schedule, just script the job. Then scroll down to the bottom where the sp_add_jobschedule is. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-02-08 : 12:20:41
|
| Thanks everyone for their help. |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-02-09 : 19:06:35
|
| FWIW, this procedure will yield all the details you'll need if you want to script a set of schedules.[CODE]exec msdb.dbo.sp_help_schedule[/CODE]HTH=================================================Men shout to avoid listening to one another. -Miguel de Unamuno |
|
|
|
|
|
|
how to script a schedule