Use this statement to trigger a named event. The event may be defined for event triggers or be a scheduled event.

Syntax

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

Parameters

Remarks

Actions are tied to particular trigger conditions or schedules by a CREATE EVENT statement. You can use the TRIGGER EVENT statement 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.

Each value is a string. The maximum length of each value is limited by the maximum page size specified by the -gp server option. If the length of value exceeds the page size, the string is truncated at the point at which the page is full.

Permissions

Must have DBA authority.

Side effects

None.

See also

• -gp server option
• ALTER EVENT statement
• CREATE EVENT statement
• EVENT_PARAMETER function [System]

Standards and compatibility

Example

The following example shows how to pass a string parameter to an event. The event displays the time it was triggered on the database server messages window.

CREATE EVENT ev_PassedParameter
HANDLER
BEGIN
  MESSAGE 'ev_PassedParameter - was triggered at ' || event_parameter( 'time' );
END;
TRIGGER EVENT ev_PassedParameter( "Time"=string( current timestamp ) );