Skip to main content
Database Administrators

Return to Question

edited title
Source Link
variable
variable
  • 3.5k
  • 4
  • 36
  • 90

How to configure Does the Maintenance Plan formaintenance plan or the notify operator task support failure notificationsnotification?

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.

Isn't failure notification supported byDoes the maintenance plan'splan or the notify operator task support failure notification?

How to configure the Maintenance Plan for failure notifications?

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.

Isn't failure notification supported by the maintenance plan's notify operator task?

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

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?

deleted 88 characters in body; edited title
Source Link
variable
variable
  • 3.5k
  • 4
  • 36
  • 90

Where is How to configure the Notify Operator Task (MaintenanceMaintenance Plan) for failure notifications?

Link: https://learn.microsoft.com/en-us/sql/relational-databases/maintenance-plans/notify-operator-task-maintenance-plan?view=sql-server-ver15

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. But I am looking to configure the alert in the maintenance plan itself. The task shown inI have added the above link does not existnotify operator task in the maintenance plan wizard task list. Where can I find this?However it doesn't have any option to set whether the notification must be sent upon success/failure/completion.

enter image description here Isn't failure notification supported by the maintenance plan's notify operator task?

Where is the Notify Operator Task (Maintenance Plan)?

Link: https://learn.microsoft.com/en-us/sql/relational-databases/maintenance-plans/notify-operator-task-maintenance-plan?view=sql-server-ver15

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. The task shown in the above link does not exist in the maintenance plan wizard task list. Where can I find this?

enter image description here

How to configure the Maintenance Plan for failure notifications?

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.

Isn't failure notification supported by the maintenance plan's notify operator task?

Post Undeleted by variable
Post Deleted by variable
Post Undeleted by variable
Post Deleted by variable
Source Link
variable
variable
  • 3.5k
  • 4
  • 36
  • 90

Where is the Notify Operator Task (Maintenance Plan)?

Link: https://learn.microsoft.com/en-us/sql/relational-databases/maintenance-plans/notify-operator-task-maintenance-plan?view=sql-server-ver15

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. The task shown in the above link does not exist in the maintenance plan wizard task list. Where can I find this?

enter image description here