|
Home > Archive > Microsoft SQL Server forum > July 2005 > DTS Job - Suspend on fail?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DTS Job - Suspend on fail?
|
|
| throat.wobbler.mangrove@gmail.com 2005-07-05, 3:23 am |
| 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.
| |
| Simon Hayes 2005-07-05, 7:23 am |
| 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
| |
| throat.wobbler.mangrove@gmail.com 2005-07-05, 7:23 am |
| 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
|
|
|
|
|