471,090 Members | 1,361 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,090 software developers and data experts.

DTS Job - Suspend on fail?

Hi,

Is it possible to somehow set a SQL Server DTS job to automatically
disable itself, when it encounters a fail, so that future scheduled
occurrences don't happen until the problem has been fixed?

I've hunted about for this on the web, but drawn a blank unfortunately!

Many thanks if anyone can help at all.

Jul 23 '05 #1
2 1563
One option would be to configure the job step to quit the job when it
succeeds, but if it fails, then to run a second step. In the second
step, you can then use sp_update_job to disable the job entirely.

Simon

Jul 23 '05 #2
Thank you Simon, that works great.

The only problem I'm having now is that a failure in my child package
doesn't appear to trigger a failure in the parent package, even though
I have 'Fail Package on First Error' set in both - will have to look
into that.
Simon Hayes wrote:
One option would be to configure the job step to quit the job when it
succeeds, but if it fails, then to run a second step. In the second
step, you can then use sp_update_job to disable the job entirely.

Simon


Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Keith Langer | last post: by
8 posts views Thread by Wim | last post: by
1 post views Thread by Jorge | last post: by
2 posts views Thread by juky | last post: by
2 posts views Thread by b.fokke | last post: by
6 posts views Thread by Robert Speck | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.