news:1156531794.487481.117190@m79g2000cwm.googlegroups.com...
>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?
>

> 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
>
> <stav***@mailinator.com> wrote in message
> news:1156531794.487481.117190@m79g2000cwm.googlegroups.com...
> >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?
> >