Monday, March 19, 2012

Make SQL Server Agent job stop after X minutes

I swear there is a way in SQL 2000 to have a SQL Server Agent job (that runs
a DTS) to stop running if it's been running for X minutes. I can't find it
though. I thought it was just a checkbox and a field for a number somewhere.
any ideas?
Rich
sp_trace_setstatus @.traceid = @.TraceID, @.status = 0
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:C99F8FAF-A4AE-40B5-B12E-B380E258A127@.microsoft.com...
>I swear there is a way in SQL 2000 to have a SQL Server Agent job (that
>runs
> a DTS) to stop running if it's been running for X minutes. I can't find
> it
> though. I thought it was just a checkbox and a field for a number
> somewhere.
> any ideas?

No comments:

Post a Comment