get triggers

Displays information about the triggers that are monitored by the RMS.

get status triggers 
	[{connection | logical connection | route | queue | rep agent | 
		partition} 
	component_name for server_name]

connection, logical connection, route, queue, rep agent, partition: Specifies the type of component to be monitored. Components are monitored objects within a server. Replication Server components are connections, logical connections, routes, queues, and partitions. Adaptive Server Enterprise components are RepAgent threads.

Returns the list of all triggers in the RMS:

get triggers

Returns the list of all triggers defined for the Replication Server INVENTORY_RS:

get triggers for INVENTORY_RS

Returns the list of all triggers defined for the connection “inventory_pds.vendor” in the Replication Server INVENTORY_RS:

get triggers connection inventory_pds.vendor for
     INVENTORY_RS

get triggers returns the following result set:

**Table 9-21: Column descriptions for get triggers**
Column	Description
Type	The type of the trigger.
Server Type	The server type of the trigger.
Server Name	The server name of the trigger.
Component Type	The component type of the trigger.
Component Name	The component name of the trigger.
Primary Connection	The name of the primary connection.
Change Value	The value of the server or component that will cause the RMS to execute the trigger’s script.
Change State	The state string of the server or component that will cause the RMS to execute the trigger’s script.
Wait	The number of seconds to wait after the initial state change before executing the trigger’s script. If waitInterval is set to zero, the script executes immediately.
Continuous	A Boolean flag that, if set to true, causes the RMS to execute the trigger’s script at every subsequent monitoring interval until the state changes. If the flag is not set, then the RMS executes the trigger script only once.
Script	The operating system script that the RMS executes when the event occurs.