Maintenance Plan - Adding narration to email

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Maintenance Plan - Adding narration to email

Author

Topic

JayKidd
Starting Member

1 Post

Posted - 2010-10-02 : 23:28:30

Hi

I'm tyring to add some additional useful information to the Reporting and Logging feature of Maintenance Plans and I was wondering how I would go about it.

If I add Print statements, Select statements, RaisError statements; none of them are verbosed in the Logging feature. Is there a way of adding more details without having to swaping to Notify Operator and recreating the reports?

Example Plan (TEST):
(1) Execute TSQL Statement Task:

RAISERROR ('123',10,1)
 SELECT '456'
 PRINT '789'

Output:

NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.4053
Report was generated on "****DELETED THIS****".
Maintenance Plan: Test
Duration: 00:00:00
Status: Succeeded.
Details:
Execute T-SQL Statement Task (NZ-NZLDMG001,51433)
Task start: 2010-10-03T16:08:36.
Task end: 2010-10-03T16:08:36.
Success

Notice that in the returned message, it doesn't verbose any of the TSQL output?

Thanks,
Jay

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources