kill long running (hung) SQL task

We have an SQL task that occasionally hangs. Is there a function to end a
task if it has been running for a determined period of time? This feature is
available in windows task scheduler, not SQL 2005?
D.
You can write a script to check for long running jobs and
schedule to run at whatever time interval makes sense for
your purposes.
-Sue
On Wed, 7 Feb 2007 08:16:00 -0800, dsm4898
<dsm4898@.discussions.microsoft.com> wrote:

>We have an SQL task that occasionally hangs. Is there a function to end a
>task if it has been running for a determined period of time? This feature is
>available in windows task scheduler, not SQL 2005?