SQL Server 7.0

[XXX]

Is there a way by which you can prevent long running jobs from executing?
For example, if a job is scheduled to run at 2.00AM every day and if you want to prevent it from executing for more that 30 seconds, how would you do it?

[tcronin]

If this is some kind of tsql you should probably look at the query governor in 7.0. If not set a user defined counter and then use a combination of
performance monitor and the sql agent to stop it from running.


------------
XXX at 8/2/99 8:14:04 PM

Is there a way by which you can prevent long running jobs from executing?
For example, if a job is scheduled to run at 2.00AM every day and if you want to prevent it from executing for more that 30 seconds, how would you do it?