Sql-server – SQL Maintenance Plan – Send email on fail

maintenancesql server

I have a maintenance plan on my SQL 2008 box –
I would like it to send an email address when (or if) it fails.
I've set up database mail, and can send a test email..

How can I do this?

Best Answer

  1. Configure SQL Server Agent to use database mail
  2. Create operator(s) mail, pager, hours, etc.
  3. Configure maintenance plan to email appropriate operator(s) based on exit condition.

http://msdn.microsoft.com/en-us/library/ms186358.aspx

http://technet.microsoft.com/en-us/library/ms175962.aspx

Related Topic