The Information Schema EVENTS table stores information about Events on the server.

It contains the following columns:

ColumnDescription
EVENT_CATALOGAlways def.
EVENT_SCHEMADatabase where the event was defined.
EVENT_NAMEEvent name.
DEFINEREvent definer.
TIME_ZONETime zone used for the event's scheduling and execution, by default SYSTEM.
EVENT_BODYSQL.
EVENT_DEFINITIONThe SQL defining the event.
EVENT_TYPEEither ONE TIME or RECURRING.
EXECUTE_ATDATETIME when the event is set to execute, or NULL if recurring.
INTERVAL_VALUENumeric interval between event executions for a recurring event, or NULL if not recurring.
INTERVAL_FIELDInterval unit (e.g. HOUR)
SQL_MODEThe SQL_MODE at the time the event was created.
STARTSStart DATETIME for a recurring event, NULL if not defined or not recurring.
ENDSEnd DATETIME for a recurring event, NULL if not defined or not recurring.
STATUSOne of ENABLED, DISABLED or /SLAVESIDE_DISABLED.
ON_COMPLETIONThe ON COMPLETION clause, either PRESERVE or NOT PRESERVE .
CREATEDWhen the event was created.
LAST_ALTEREDWhen the event was last changed.
LAST_EXECUTEDWhen the event was last run.
EVENT_COMMENTThe comment provided in the CREATE EVENT statement, or an empty string if none.
ORIGINATORMariaDB server ID on which the event was created.
CHARACTER_SET_CLIENTcharacter_set_client system variable session value at the time the event was created.
COLLATION_CONNECTIONcollation_connection system variable session value at the time the event was created.
DATABASE_COLLATIONDatabase collation with which the event is linked.

The SHOW EVENTS and SHOW CREATE EVENT statements provide similar information.

Comments

Comments loading...