Post reply

SQL Alert question

  • November 11, 2010 at 3:07 am

    #388208

    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

    #1249381

    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

    #1249517

    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

    #1249792

    Thanks. The article explained my concern.

  • May 19, 2013 at 8:12 am

    #1616453

    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