Post reply

Help! Need Notification of "lack of change"

  • December 3, 2002 at 8:27 pm

    #80421

    Hi, I need to monitor a table for lack of change. I.E. if records are not added for a specific period of time (such as 3 minutes)I need a email or other notification sent. Basically I have a log table that is updated every few seconds. If this update stops I need to know right away. Any suggestions?

    Thanks,

    Ray

  • December 3, 2002 at 9:05 pm

    #442999

    Sounds like a job for SQLAgent. You can check for the last update and if it's not within your time frame, use xp_sendmail to fire off the email. Or, when you write to the log you could update another table consisting of a single row. Check the time there. It should be loads faster than hitting the log table.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

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

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