max execution time of an sql job

[Dracosms]

Hi,

I've scheduled a job (executing a DTS).
Is there any way I can set a maximum amount of time a job like that can "execute" ? I mean : If the job isn't done after 15 minutes, It should stop.

Is this possible ? How ?

Greets,

Dracosms

 

[mrdenny]

You would need to write another job, that checks the most recent start time, and if the specified time has enablsed and the job is still running stop the job.

However wouldn't stopping this job cause problems. It would probably be better to try to speed up the job, rather than just stop the job.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)