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?
There is sp_stop_job procedure that stops the jobs. see http://msdn.microsoft.com/en-us/library/ms182793 for details.
精彩评论