SMTP Notification when condition met

  • I'm wanting to get SMTP notification when one of the the SQL columns in a table (RUNSTATUS) gets more than 2 consecutive entries of '3' .  This will alert me when we have issues on our Scheduler box.

    Appreciate thoughts/replies

     

  • You probably need a trigger to catch the inserts and compare them to the previous entries. Assuming you can do this and have some ordering criteria, I'd have the trigger drop a value in some table.

    Then have a job that queries the table every minuite and sends a mail message if it sees the value.

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

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