TRIGGER EVENT statement
630
TRIGGER EVENT statement
Use this statement to trigger a named event. The event may be defined for
event triggers or be a scheduled event.
TRIGGER EVENT
event-name
[ (
parm
=
value
, … ) ]
Must have DBA authority.
None.
"ALTER EVENT statement" on page 387
"CREATE EVENT statement" on page 435
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.
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. The TRIGGER EVENT
statement allows you to explicitly supply these parameters, in order to
simulate a context for the event handler.
Function
Syntax
Permissions
Side effects
See also
Description
Parameters