Checking maintenance plan logs

  • Does anyone have a way of checking all the emails sent by maintenance plans? With 12 instances and over 60 databases, my maintenance plans are generating up to 100 emails daily. Is there any software which will analyse all this mail? I need to know when they have failed (ok with the subject including "Success" or "Failed"), and also when the mail has not been sent. All this can be done, but it is time consuming and very dull. I'd appreciate any advice.

  • This should get you started in the right direction ...

    SELECT * FROM msdb.dbo.sysmail_log

Viewing 2 posts - 1 through 2 (of 2 total)

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