drop event trigger

Description

Removes a trigger that the RMS is monitoring. A trigger identifies a process or script that is executed by the RMS. Set triggers up using the add trigger command.

Syntax

drop status trigger 
	[{connection | logical connection | route | queue | rep agent |
		partition} 
	component_name] for server_name
	status changes to state

Parameters

status: Specifies the type of trigger.

connection, logical connection, route, queue, rep agent, partition: Specifies the type of component.

component_name: Specifies the name of the component. 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.

server_name: Specifies the name of the server for which the trigger is defined that is being dropped.

state: Specifies the state of the event trigger that is being dropped. See Appendix C, “RMS Server and Component States” for state information.

Examples

Example 1

Removes the “DOWN” status trigger for the server INVENTORY_RS:

drop status trigger for INVENTORY_RS
    status changes to DOWN

Example 2

Removes the “SUSPENDED” status trigger for the connection “inventory_pds.pdb1” of server INVENTORY_RS:

drop status trigger connection inventory_pds.pdb1
    for inventory_rs
    status changes to SUSPENDED

Usage

drop trigger returns the following result set:

**Table 9-10: Column descriptions for drop event trigger**
Column	Description
Action	The name of the action
Result	The result of the execution