|visits||member for||2 years, 1 month|
|seen||Oct 7 '14 at 19:34|
SQL Maintenance Plan - Send email on fail
If you want to be notified per task (when a task fails, rather than when a plan fails), double click on a green arrow to open its properties and change the Value to Failure. You can create multiple arrows ("precedence constraints"?) from a single task, so you can have one which performs the next task upon Completion, and another which sends an email on Failure. If the task fails, the condition for both arrows will be met and both the next task and the email task will be run.