Maintenance Plan report Not Sending

Question

Post reply

Maintenance Plan report Not Sending

gary.cobden

SSC Journeyman

Points: 80
More actions
January 14, 2014 at 2:41 am

#303005

I have all my servers set up in the same way, and despite configuring Maintenance Plans to send the Report by e-mail, on some servers the reports are not sending.
Database Mail is configured correctly, and I receive the job notification completion e-mails from all servers; however, on some the Maintenance Plan report does not get sent despite Reporting/logging being selected and mail operator included.
Any assistance appreciated

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

HanShi SSC-Dedicated Points: 33507 More actions · Answer 1

Can you check if the mail is being sent (and failed) or the mail has not been sent at all?

You can execute the code below on the instance where you execute the maintenance plan.

SELECT

sysmail_allitems.mailitem_id

, sent_status

, recipients

, subject, body

, send_request_date

, send_request_user

, sent_date

, sysmail_allitems.last_mod_date

, sysmail_event_log.event_type

, sysmail_event_log.description

FROM msdb.dbo.sysmail_allitems

LEFT OUTER JOIN msdb.dbo.sysmail_event_log

ON sysmail_allitems.mailitem_id = sysmail_event_log.mailitem_id

where send_request_date > dateadd(dd, -7, getdate()) -- query the last 7 days

order by

send_request_date desc

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

gary.cobden SSC Journeyman Points: 80 More actions · Answer 2

As intimated in my post, the mail/notification is not being sent.

Other Mail from the server is being received OK

Lynn Hendricks SSC Enthusiast Points: 142 More actions · Answer 3

Hey, did you ever figure out why you were not getting the logging emails from your maintenance plans?

I have the same problem. I get emails from all of my SQL agent jobs, but am not getting the logging info from the maintenance plan and I do have them set up correctly.

I do have some servers that do send the emails, and ones that don't. Whats funny is I have an old SQL 2000 server and it sends the logging reports fine. but a 2012 one that doesn't.

any one know of a fix for this?

thanks much