Send email when certain values present in table

Last Post 18 Apr 2009 10:03 AM by phsatech. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
phsatech
New Member
New Member

--
18 Apr 2009 10:03 AM
I'm not much of a programmer, but was looking for some ideas on what I'm trying to accomplish:

I'd like to monitor a table, and do a select on that table to find out if 2 values are present such as this SELECT STARTED, WORKING FROM TABLE WHERE STARTED => '1' and WORKING => '1'

If this condition is met then email out (cdosys) 'App Messages Stuck'

Appreciate feedback.


Acceptable Use Policy
---