SQL Server 2008 - Maintenance Plan E-mail notification - Notify Operator Task

• jeffmc

  SSC-Addicted

  Points: 438

  More actions

  December 22, 2010 at 7:28 am

  #244654

  I have setup a few maintenance plans in SSMS to perform backups. The backups are running fine but i am having 2 issues with notification.

  1. I have setup Different Notify Operator Tasks for success and failure. I get the message (except on case), but I also get a detailed completion report like below. How do I disable this report from being sent? I not really sure how/where I enabled it.

  "Microsoft(R) Server Maintenance Utility (Unicode) Version 10.0.1600 Report was generated on "GEORGE".

  Maintenance Plan: IntraDay_Logs

  Duration: 00:00:02

  Status: Succeeded.

  Details:

  Back Up Database (Transaction Log) (GEORGE) Backup Database on Local server connection

  Databases: CIMAEnMinLtd,Phoenix,PPPCo,PPPCo_Fileroom,ReportServer

  Type: Transaction Log

  Append existing

  Task start: 2010-12-22T08:11:10.

  How do I disable the "...

  2. One of my Maintenance Plans only sends failure notices not success notices. Where do I debug this issue?

  Thanks

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  January 12, 2011 at 4:41 pm

  #1272728

  1. A better method would be to use Execute SQL Task and send Email using that. However, for this to work you need to setup the DatabaseMail first

  EXEC sp_send_dbmail @profile_name='Profile_Name',

  @recipients='youremail@Example.com',

  @subject='Test message',

  @body='This is the body of the test message.'

  2. You need to troubleshoot that in the Maintenance Plan Log file.

  Thank You,

  Best Regards,

  SQLBuddy