E-mail Operator only on Maintenance Plan Failure

sql-server email maintenance-plan
SeanFromIT picture SeanFromIT · Mar 14, 2011 · Viewed 8k times · Source

I know you can use Reporting and Logging wizard to setup a report e-mail for a maintenance plan, but is there a way to only send this out if there was a failure? I'm interested in receiving emails on errors for Back Up Database and Check Database Integrity Tasks in a maintenance plan.

Answer

DForck42 picture DForck42 · Mar 14, 2011

right-click the sql agent job, click properties, go to notifications. Set up an operator witht he appropriate email and then select email, select the operator, 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 job (each sub plan for a maintenance plan). so you'll have to set up the notification on each part of the subplan (if you have multiple subplans).

How to create an operator.

Related questions

Stored procedure using SP_SEND_DBMAIL sending duplicate emails to all recipients

I have a stored procedure that is run every night which is supposed to send the results of a query to several recipients. However on most days it ends up sending a duplicate email a minute later. The code I …

Read More
NVARCHAR(?) for Email addresses in SQL Server

For Email addresses, how much space should I give the columns in SQL Server. I found this definition on Wikipedia: http://en.wikipedia.org/wiki/Email_address The format of email addresses is local-part@domain where the local-part may be …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More