sql server dts: Hi,

I have a number of DTS's that are executed each morning via a Scheduled Job.

Sometimes I find that the Job has got "stuck" on a Step (DTS) and does not
"stop" until I manually stop the job myself through EM.

Question is: How can I give my DTS's a Maximum Expected Run Time?

e.g. Job Step 2 - which runs DTS "MySecondDTS" should only take 2 minutes to
run, therefore I'd like to set a Max run time of 10 minutes.

Thanks for helping.

Hello Jon,

AFAIK you can't. Once you kick off the process it runs until it completes.
I guess the problem is that what do you want to do if an INSERT statement
takes longer than expected because of maybe resource contention? What will
happen to your transactions? Roll them back? What about importing a file
and the file host is slow today. What do you want to do? Kill the load?

Even if you had a table which was logging job execution times and you could
query it to find out how long things were taking. A lot of what I mentioned
above still applies. If you stop the job there will still be things that
need to be rolled back or run to completion withinn the package before the
stopping of the job can happen.




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]