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 |
|
yakoo
Constraint Violating Yak Guru
312 Posts |
 Posted - 2002-03-07 : 15:15:25
|
| Is there anyway in SQL to specify a job to restart if it has stalled?Just like in Windows under scheduled tasks, where you can specify the task to stop after 30 minutes. I have a DTS job that seems to occasionaly stall out and I would like to tell the job to stop if it has run for more than 30 minutes.Is there a way to do this or is there a way to write another job that would check the job history of a specified job and tell it to stop after it has executed for more than xx minutes? |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-03-07 : 15:17:55
|
| You should see why the job is "stalling out", as you say. That's never normal behavior, and you shouldn't try to build functionality around it. Restarting this "stalled" job, for example, will likely mask some error. |
 |
|
|
yakoo
Constraint Violating Yak Guru
312 Posts |
Posted - 2002-03-07 : 15:39:50
|
| I have a DTS package that executes two other dts packages.It seems that in one of these children packages that a connection to another SQL server times out and doesn't let the parent know and thus the parent package stalls.It is most likely becuase the Execute SQL Task have an infinite Time out. I will try setting that to 60 seconds to see if that works.Ill keep you guys posted. |
|
|
|
|
|
|
DTS Job