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 |
|
smccreadie
Aged Yak Warrior
505 Posts |
 Posted - 2001-07-02 : 11:03:52
|
| I've got a daily DTS pull scheduled through SQL Agent that occasionally hangs. It pulls several tables from an Access database application across the network. For some reason, it will hang in the "executing step 1" stage and has to be manually stopped.Is there a way on a job to kill a job that exceeds a specified amount of time? This only happens about once every two months but it does cause some locking issues for the users during the daytime.Thanks |
|
|
|
|
|
killing a hung job