• Not Answered

SQL Event for One Time Event Listener?

Currently in our recipe, we are using a polling method  using repeating parameters to advance to the next work instruction,  but I am trying to find a better way for this type of scenario.  I have heard talking about using one-time event listening as an alternative ( Event Monitor). 

Does this work only with OPC Events as trigger? Can I use SQL Events as trigger?

1 Reply

  • It may depend on your version of Event Monitor, but as far as I can tell, SQL Events have enough of the same attributes as OPC Events to satisfy your initial inquiry, most importantly a Trigger Value. There is no built in acknowledgment mechanism for SQL (though if that was needed somehow I suppose you could just write it into a Stored procedure).