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?