November 11, 2010 at 3:07 am
I thought the SQL alert are trigged when SQL Agent found error message in SQL Error log.But when i diabled SQL Server log event on Windows event log, i couldn't receive the alert.
It seems SQL Agent read error from Event log then trigged the alert.
Currently i am confused. Could anybody told me how SQL alrert are tiggered.
Thanks in advance.
November 11, 2010 at 3:26 am
SQL Server Agent reads the application log and compares events written there to alerts that you have defined.
http://msdn.microsoft.com/en-us/library/ms180982(v=SQL.100).aspx
November 11, 2010 at 8:07 am
If you havent already you probably want to define your alerts 11-24 are the usual suspect you can find them on BOL
November 11, 2010 at 6:16 pm
Thanks. The article explained my concern.
May 19, 2013 at 8:12 am
1)Configure email if sql agent job fail.
2) check job history insert into one table then on insertion show alert.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply