SQL Alert question

  • 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.

  • 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

  • If you havent already you probably want to define your alerts 11-24 are the usual suspect you can find them on BOL

  • Thanks. The article explained my concern.

  • 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