"DHatheway" wrote:

> I set up a package with a SQL task that may or may not fail (I do a
> raiserror if it fails). There's a notfication task dependent on the SQL
> task step that will only fire on a failure in the SQL Task.
>
> If the failure path is taken and the notification step works, I consider
> this a "success." However, when I schedule this as a job, the SQL Task
> fails and the notification step is run, the job status is "failed."
>
> How can I set the job's overall status to "success" as long as the
> notification step worked? I tired a few permutations of "failonerror" and
> "failpackageonerror" but couldn't find a winning combination. The step
> result is "readonly" so I didn't try modifying that.
>
> Any thoughts? I imagine others have run into this but I reviewed the
> postings here but didn't notice anything helpful.
> Thanks!
>
>