ALTER TRIGGER
Use the ALTER TRIGGER
command to change
the settings of an existing trigger. You can change more than one
setting in a single ALTER TRIGGER
command.
Syntax
ALTER TRIGGER trigger_name
SET PRIORITY integer
SET ENABLED { TRUE | FALSE }
SET GROUP trigger_group_name
SET DEBUG { TRUE | FALSE };
Use SET PRIORITY to change the priority of a trigger to a value between 1 and 20. The lower the number, the higher the priority.
Use SET ENABLED TRUE to activate a trigger or SET ENABLED FALSE to deactivate a trigger. If a trigger is ENABLED, it fires when the associated incident occurs. If a trigger is not ENABLED, it does not fire when the associated incident occurs.
Use SET GROUP to change the trigger group of the trigger to the specified group name.
Use SET DEBUG to turn debugging on or off for the
trigger. If on, debugging information is sent to the ObjectServer
message log, if the message level is set to debug
.
Example
alter trigger mytrig set priority 1;