0

I want to notify an operator upon failure of the maintenance plan.

I know that I can configure the alerts via the agent job. But I am looking to configure the alert in the maintenance plan itself. I have added the notify operator task in the maintenance plan. However it doesn't have any option to set whether the notification must be sent upon success/failure/completion.

Does the maintenance plan or the notify operator task support failure notification?

Improve this question

1 Answer 1

Reset to default
1

No, there is no option for email on failure at the maint plan level. You have to do that either inside the plan adding tasks as explained below or modify the Agent jobs (not recommended).

One option is to modify the main plan (not the agent job) and add "Notify Operator Task" task(s) and connect an "On Failure" control flow from each task to this/these "Notify Operator Task" task(s). You won't get the report file in the email, though.

This is one of many reasons why many of us prefer alternative solutions, like for instance Ola Hallengren's maintenance solution. https://ola.hallengren.com/

Improve this answer
8
  • Please can you clarify what you mean by "not the way that the regular maint plan emailing work."?
    – variable
    Commented Dec 14, 2021 at 8:17
  • I modified and added a bit to that paragraph above.
    – Tibor Karaszi
    Commented Dec 14, 2021 at 9:14
  • Will either of the below help me to send the email for failure notification for my scenario: 1. set up notify operator task upon task failure in maintenance plan; 2. configure failure notification on the job.
    – variable
    Commented Dec 14, 2021 at 9:16
  • Yes, both allow for that. Notify Operator Tasks is what I referred in my answer above, but I had the wrong name for the task name (not corrected). Another options is to add a failure notification for the job, but we don't recommend that you modify the jobs that are created by a maint plan.
    – Tibor Karaszi
    Commented Dec 14, 2021 at 10:33
  • Interesting, what's the reasoning to not recommend modifying the Job created for a Maintenance Plan, especially with something rather benign like enabling Notifications?
    – J.D.
    Commented Dec 14, 2021 at 12:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.