October 22, 2014 at 9:56 am
I have an exeSQL task where I have the on failure precedent constraint pointing to an email task. This same email task has another on failure precedent constraint pointing to it from a Dataflow task as well. The problem is when I add an extra comma in the script of the ExeSQL task to force a failure to test my Email task, the ExeSQL task fails, the script in the eventhandler runs but the email task on the end of the OnFailure task never runs. Any ideas why this is happening?
October 22, 2014 at 1:34 pm
If I understand it correctly, you have two tasks connected to the Send Email Task with OnFailure precedence constraints?
By default, multiple precedence constraints are combined using the AND constraint, meaning all tasks need to fail before the Send Mail Task is activated.
If you want to send an email if one or more tasks fails, you need to double click on a constraint and change it to OR.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 23, 2014 at 7:25 am
Yep, that was it. Bit of a brain cramp for a little while
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply