Re: Customizing maintenance plan reporting in SQL2005

Tech-Archive recommends: Speed Up your PC by fixing your registry

Most of the features in the 2005 MP's just plain fall short of useful. I
would suggest that you roll your own reporting. One thing the new MP's do
give is the ability to have control flow. So you can add a task for on
complete and failure that send an email in what ever format you want using
database mail. You will know the job completed successfully or not via the
task that fired (completed or failed). You know what the maintenance tasks
were and you can find out most any details you want via sp_helpjob. From
that you should be able to create your own custom message and subject.

--
Andrew J. Kelly SQL MVP

<stavros@xxxxxxxxxxxxxx> wrote in message
news:1156531794.487481.117190@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have maintenance plans set up in SQL2K that e-mail status reports to
me upon completion. The e-mail subject lines have very handy
formatting which includes the job name and final status, like "SQL
Server DB Maintenance Report - SERVERNAME\System Backups (Success)".
With Outlook rules, I can use the detail in the subject line alone to
manage these e-mails.

The format has changed with SQL2005. The maintenance plans send out
e-mails with the flat subject line "SQL Server Message", nothing more.
The details are in the body of the message, but this is much more
difficult if not impossible to parse with Outlook rules.

Is there a way to customize the maintenance plan e-mail reporting?
I've tried turning off the maintenance plan e-mail and using
notification from the job level instead, but that still doesn't give me
quite what I want. I'm looking for notification when the jobs
complete, with job details and outcome status in the subject line. Any
ideas?



.

Relevant Pages

  • Re: Customizing maintenance plan reporting in SQL2005
    ... Thanks, Andrew. ... Is there a way to customize the maintenance plan e-mail reporting? ...
    (microsoft.public.sqlserver.tools)
  • Re: Emailing SQL 2000 maintenance report via SMTP?
    ... Other possible mechanisms might mbe Notification Services or Reporting ... > DB maintenance plan just stops doing what it should, ... > I know the old SQL 6.5 used to provide SQL Mail, but this links in with MS ... > Exchange Server and I don't use this. ...
    (microsoft.public.sqlserver.programming)
  • RE: Emailing SQL 2000 maintenance report via SMTP?
    ... Other possible mechanisms might mbe Notification Services or Reporting ... > What I would like to do is email the maintenance plan to a designated email ... > I know the old SQL 6.5 used to provide SQL Mail, but this links in with MS ... > Exchange Server and I don't use this. ...
    (microsoft.public.sqlserver.programming)
  • Re: Maintenance Plan Not Performing Backup
    ... and select Database Maintenance Plan History. ... select properties and then select the reporting ...
    (microsoft.public.sqlserver.server)