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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-26 : 11:34:04
|
| Christina writes "I have a job that when it runs longer then 15 minutes, I want to have another job setup to stop the first job and restart it automatically. Is this possible?Christina" |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-08-26 : 11:38:56
|
| Yes, you can insert the begin time and have a second job which records this begin time and checks 15 minutes later to see if the first job has finished by updating the begin time to an end time. If not, then you can have the second job kill the first using the KILL tsql command.*************************Someone done told you wrong! |
 |
|
|
|
|
|
SQL Server Scheduled Jobs