Home Forums SQL Server 2008 SQL Server 2008 - General Script to montior ErrorLog every 1 hour RE: Script to montior ErrorLog every 1 hour
homebrew01
SSC Guru
Points: 55544
More actions
August 17, 2013 at 7:18 am
#1642408
You can put your query in sp_send_dbmail.
I do something similar looking for failed job steps. I run the query, and if the count is > 0, I run sp_send_dbmail with the query embedded in it.