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?

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
<dsm4***@discussions.microsoft.com> wrote:

Show quoteHide quote

SQL Server Management Studio - long names in tabs
Help with SQL 2005 and Sourcesafe 6
SSIS and polling
Little Lock Symbols
SQL - Fast LOCALHOST , Slow IP