"MZeeshan" <mzeeshan@community.nospam> wrote in message
news:659D8612-E1DC-4261-A7B6-2D0A97E4409B@microsoft.com...
> Hello-
>
> I am using the following logic:
>
> Step1--on success-->step2--on success-->step3---on success--->Success
Email
> -
> IF ANY step (1, 2 and 3) fails then...
>
> -----on failure--->Failure E-mail/Alert
>
> The intention is to get page/e-mail for failure and e-mail only for
success
> (to keep track of times when the task is disabled).
>
> Now, I am not using any Microsoft provided mailing mechanism. Instead I am
> calling a task ('Execute SQL Task') like
>
> EXEC sp_user_counter3 900850
> WAITFOR DELAY '00:01:10'
> EXEC sp_user_counter3 0
>
> Now the problem...
>
> The success criteria works fine but anytime there is a failure that task
> bombs out and the next task is not executed.
>
> What should I do to execute the alternate task based on ON FAILURE
workflow
> status? Alternatively, what is the purpose of 'On Failure' workflow if it
> cannot capture errors?
>
> --
> Regards,
> MZeeshan