Post reply

setup SQL alert notify DBA about windows event log error

  • March 1, 2013 at 10:56 am

    #271083

    Is there a simpler way to setup SQL alert in SSMS to notify DBA when an error log is written to windows event log.

    For example if the event type is an Error, or I know the event ID, can I set up the alert in SSMS?

    Thanks

  • March 4, 2013 at 2:53 am

    #1592925

    I wrote/modified a check script running every hour which keeps looking after certain keywords in the errorlog I predefined. If it finds something, I send me an email. But email is not reliable. Image you are in an meeting or otherwise prevented for any reason you can't read urgent the urgent mail in that time you should. And the more mails you receive, the harder it get's to distuingish beetween important and unimportant.

    Greetz
    Query Shepherd

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply