SHOW EVENTS

SHOW EVENTS displays basic information about all scheduled tasks in a specified schema.

Precautions

Operations related to scheduled events are supported only when sql_compatibility is set to 'B'.

Syntax

ShowEvents ::=SHOW EVENTS
    [{FROM | IN} schema_name]
    [LIKE 'pattern' | WHERE condition]

Parameter Description

• {FROM | IN} schema_name

  Specifies the schema to be queried. By default, the current schema is queried.

• LIKE 'pattern'

  Matches a scheduled task by name. If this parameter is not specified, all scheduled tasks in the current schema are printed.

• WHERE condition

  Forms an expression for row selection to narrow down the query range of SHOW EVENTS. condition indicates any expression that returns a value of Boolean type. Rows that do not meet this condition will not be retrieved.

Examples

--View information about all scheduled tasks queried through pattern matching '_e' in the event_a schema.
MogDB=# SHOW EVENTS IN event_a LIKE '_e';