Alerting on informational messages

  • I'm troubleshooting an I/O stall problems on a server. Ideally, I would like to fire a Sql Alert on the "Sql Server has encountered...to complete..." message but this isn't an actual error so the alert has nothing to go on.

    Any cleaver work arounds?

    David

  • Write the info to a table and create a new procedure and schedule it to run every 1/5/10 minutes to send an email based on your criteria using sql mail...

     

    MohammedU
    Microsoft SQL Server MVP

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

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