Configuring ObjectServer acknowledged event triggers

Two triggers are provided in hpom_automation.sql, one for the OPC_MSG_EVENT_ACK event and one for the OPC_MSG_EVENT_UNACK event. If deployed, these triggers update the Acknowledged field of all event records with the same EventId as these events.

For OPC_MSG_EVENT_ACK, the Acknowledged field will be set to 1. For OPC_MSG_EVENT_UNACK, the Acknowledged field will be set to 0.

To install the triggers, run the following command:

cat $OMNIHOME/probes/<arch>/hpom_automation.sql | $OMNIHOME/bin/nco_sql -server <server> -user <user> -password <password>

To remove the triggers, run the following command:

cat $OMNIHOME/probes/<arch>/remove_hpom_automation.sql | $OMNIHOME/bin/nco_sql -server <server> -user <user> -password <password>