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 |
|
kdubb777
Starting Member
24 Posts |
 Posted - 2007-08-22 : 15:19:36
|
| In SQL 2000 you can schedule a job to run each time the agent starts. I don't see that option now in 2005. Does anyone know what happened to that or how to achieve that. I could do a stored proc with the proc option I guess but why did they remove that functionality or maybe I am not seeing it.Thanks |
|
|
mandm
Posting Yak Master
120 Posts |
Posted - 2007-08-22 : 15:46:48
|
| In the Schedules Dialog under the name is a Schedule Type. When the checkbox is enabled it will give you a drop down that allows it to run when the agent start. You get to it by choosing schedules then edit from the job properties dialog.HTH |
 |
|
|
|
|
|
Run SQL job each time agent starts