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

Multiple constraints follow AND logic, so all tasks would, have to fail for
the failure mail to be sent. Try individual error logging tasks for each
worker task.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com


"MZeeshan" <mzeeshan (AT) community (DOT) nospam> wrote