Next badge 0/1
~21 people reached
- 0 posts edited
- 0 helpful flags
- 3 votes cast
|asked||Purpose of Keywords in a Performance Monitor Data Collector Set?|
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.