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>