Schedule job on SQL Server Agent to stop

Question

Possible Duplicate:
SQL Server Agent Job Timeout

Can a scheduled job on SQL Server 2005 be scheduled to be stopped if it runs more than a certain number of hours? Just like the scheduled task in windows?

http://stackoverflow.com/questions/1588599/sql-server-agent-job-timeout Duplicate. — Edgar Velasquez Lim, Aug 05 '11 at 02:26

score 0 · Answer 1 · edited Aug 05 '11 at 04:19

0

There is sp_stop_job procedure that stops the jobs. see http://msdn.microsoft.com/en-us/library/ms182793 for details.

edited Aug 05 '11 at 04:19

John Saunders

160,644
26
247
397

answered Aug 05 '11 at 02:26

Alex_L

2,658
1
15
13

2

-1: he asked how to stop the jobs automatically if they take too long. – John Saunders Aug 05 '11 at 04:20
the question was edited at least 2 times after I answered. – Alex_L Aug 05 '11 at 04:28
Original: "Can a scheduled job on MS SQL 2005 be scheduled to be stopped if it runs more than a certain number of hours? Just like the scheduled task in windows?" – John Saunders Aug 05 '11 at 05:28

Schedule job on SQL Server Agent to stop

1 Answers1