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>