Email operator only when a service plan fails

I know that you can use the Report and Logging Wizard to configure the report email for the service plan, but is there a way to send this message only in the event of a failure? I am interested in receiving error emails for the Back Up Database and Check Database Integrity Tasks for maintenance.

+3
source share
1 answer

right click on the sql agent job, select properties, go to notifications. Set up an agent with the appropriate email, then select an email address, select an agent, and then when the job fails. Click OK and you should be good to go. note that this solution will only take care of one sql server agent task (each sub-plan of the service plan). therefore, you will need to set up a notification for each part of the subplan (if you have several subplans).

How to create an operator.

+5
source

All Articles