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 - 2001-09-18 : 10:51:16
|
| Martin writes "HiI have a job that is scheduled to run every 15 minutes. The process is basically dumb, if the data did not get processed this tiim it will next etc,This job occasionally gets stuck somewhere inside a stored proceedure and does not finish, Cause unkown at this point, once again if it did not work this time it will next. The problem is that the job may run for many hours before it is noticed (ie. stock not receipted into the warehouse etc. or I have a look in the morning). Once cancelled the Scheduled job will work quite happily next time.The Server is running nt4 sp5 and SQLServer 7.0 sp2So after all of that My question is.....Is there a way of timing out an SQL 7.0 job if it has been running too long.Either within SQL or an external scavenger process.ThanksMartin Babb" |
|
|
|
|
|
Timing out a Job