November 29, 2011 at 12:46 pm
I have db integrity check jobs set up using the statement below. I set the sql job to notify me upon completion or failure using notifications.
The jobs always succeeds, but I am looking for a way to include the results of the sql statement in the body of my email notification.
Any suggestions?
USE [MyDB]
DBCC CHECKDB(N'MyDB') WITH ALL_ERRORMSGS
November 29, 2011 at 12:50 pm
see this post bu Gianluca, and his crosspost to his blog;
it does exactlyt what you are after:
http://www.sqlservercentral.com/Forums/FindPost1212804.aspx
by coincidence, he jsut updated that older thread.
Lowell
November 29, 2011 at 1:33 pm
Very nice - Thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply