Alerts for Field Values RRS feed

  • Question

  • I'm creating a Process Control application that will save various data fields to SQL Server 2005.  Part of the data will be input via a VB hand-held application which was created on the CE 5.0.  The rest of the data will be collected via plant equipment which will interface will PLCs on the production floor.  There are approximately 25 different attributes which will be stored in a SQL server table.

    The next part of the program is where I'm still trying to figure out what to do.  The user wants me to create 3 alert levels that will involve 1) Checking to see IF a reading was manually input 2) Checking to see if the value passed or failed.  The FIRST alert involves notifying the operator via the hand-held or some other technique.  The SECOND alert involves checking back after a set time interval (15 minutes, 30 minutes, etc.) to see if the attribute passed or failed and then taking a higher action - such as an email, text message or phone call to a higher level manager.  If the second check fails, the same escalation process continues with the THIRD alert level - and another action takes place such as a message being sent to yet a higher level manager...  Presumably, once the status check passes, the alert level is re-set back to 0.  But I'm thinking that the process that checks for the failed attributes will need to continue to run in the background - probably at set intervals.   

    The reason why I posted the question in this forum is that I'm not sure if this can be done on SQL Server 2005 or if it is something that should be done on VB.NET with some sort of a gobal timer object that will check the attributes and handle the alerts.
    Saturday, February 13, 2010 7:10 PM