Search code examples
sql-servermaintenance-plan

Email Daily Maintenance Plan Report


Im currently running a Maintenance Plan on SQL that do the following:

  • 1 daily full backup

  • Hourly transaction log backup

  • 1 daily maintenance cleanup

On the reporting options I have it set up to send a report to an email recipient, so now Im getting an email hourly,

Is it possible to receive a summary email, for example at the end of the day with results of all the sub plans? Any suggestion on how to accomplish something similar?


Solution

  • I got an answer from serverfault:

    https://serverfault.com/questions/250847/email-daily-maintenance-plan-report