TRIGGER EVENT statement

Description

Triggers a named event. The event may be defined for event triggers or be a scheduled event.

Syntax

TRIGGER EVENT event-name [ ( parm = value, ... ) ]

Usage

Actions are tied to particular trigger conditions or schedules by a CREATE EVENT statement. You can use TRIGGER EVENT to force the event handler to execute, even when the scheduled time or trigger condition has not occurred. TRIGGER EVENT does not execute disabled event handlers.

parm = value When a triggering condition causes an event handler to execute, the database server can provide context information to the event handler using the event_parameter function. TRIGGER EVENT allows you to explicitly supply these parameters, to simulate a context for the event handler.

When you trigger an event, specify the event name. You can list event names by querying the system table SYSEVENT. For example:

SELECT event_id, event_name FROM SYS.SYSEVENT

Side effects

None

Permissions

Must have DBA authority.

See also

ALTER EVENT statement

CREATE EVENT statement

Chapter 6, “Automating Tasks Using Schedules and Events” in the System Administration Guide: Volume 2