Friday 20 February 2009

Unwanted emails when Maintenance Plan runs

Since we setup DatabaseMail on our server at work we started to get the following kind of email whenever a maintenance plan ran.

NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.4035 Report was generated on "server".
Maintenance Plan:
Duration: 00:00:01
Status: Succeeded.
Details:
Back Up Database (Transaction Log) (server) Backup Database on Local server connection
Databases:
Type: Transaction Log
Append existing
Task start: 2009-02-20T08:30:02.
Task end: 2009-02-20T08:30:03.
Success

We had looked at all the notification setting but couldn't find anywhere that told SQL server to send an email when a maintenance plan ran.

Finally with the help of a post we found that this feature can be switch on or off by doing the following

  • Open Management Studio
  • Connect to a database server instance
  • Drill down to Management -> Maintenance Plan
  • Click on the maintenance plan that is causing the issue.
  • Click on the icon next to 'Manage Connections'. If you hover over it should display 'Reporting and Logging'.
  • It will display the window below
  • Make sure the checkbox labelled as 'Send report to an email recipient' is not check to stop the emails being sent.
  • Lastly save the Maintenance Plan.

Hope this helps someone

No comments: