Home Forums SQL Server 2005 Business Intelligence Task connected to Failure constrain not executing after ExeSQL task RE: Task connected to Failure constrain not executing after ExeSQL task

  • 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