Timeout for JOBS

[beechill4]

Hi,

I wish to have a timeout period for all my sql server (2005) jobs. I have gone into the properties of SQL Server agent in mgmt studio and set the job system timeout to 600 seconds but some jobs continue to run for over 1 hour.

Can someone offer some advice please?

Thanks

 

[olahallengren]

I'm not sure what setting it is that you've changed. I do not know of any setting to control how long the SQL Server Agent Jobs are allowed to run.

One approach that some people are using is to create a special monitor job that keeps track of the other jobs.

Another approach that could be useful in some scenarios is to use the SET LOCK_TIMEOUT setting in the start of your T-SQL job step. This means that if the job is hanging because of that a table is locked, then the job fails after the specified time.

I'm using SET LOCK_TIMEOUT in my index optimization stored procedure.

http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html

Ola Hallengren

http://ola.hallengren.com