Information Schema EVENTS Table

The Information Schema EVENTS table stores information about scheduled events on the server, including their timing, definition, and status.

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

It contains the following columns:

Column	Description
EVENT_CATALOG	Always def.
EVENT_SCHEMA	Database where the event was defined.
EVENT_NAME	Event name.
DEFINER	Event definer.
TIME_ZONE	Time zone used for the event's scheduling and execution, by default SYSTEM.
EVENT_BODY	SQL.
EVENT_DEFINITION	The SQL defining the event.
EVENT_TYPE	Either ONE TIME or RECURRING.
EXECUTE_AT	DATETIME when the event is set to execute, or NULL if recurring.
INTERVAL_VALUE	Numeric interval between event executions for a recurring event, or NULL if not recurring.
INTERVAL_FIELD	Interval unit (e.g., HOUR)
SQL_MODE	The SQL_MODE at the time the event was created.
STARTS	Start DATETIME for a recurring event, NULL if not defined or not recurring.
ENDS	End DATETIME for a recurring event, NULL if not defined or not recurring.
STATUS	One of ENABLED, DISABLED or /SLAVESIDE_DISABLED.
ON_COMPLETION	The ON COMPLETION clause, either PRESERVE or NOT PRESERVE .
CREATED	When the event was created.
LAST_ALTERED	When the event was last changed.
LAST_EXECUTED	When the event was last run.
EVENT_COMMENT	The comment provided in the CREATE EVENT statement, or an empty string if none.
ORIGINATOR	MariaDB server ID on which the event was created.
CHARACTER_SET_CLIENT	character_set_client system variable session value at the time the event was created.
COLLATION_CONNECTION	collation_connection system variable session value at the time the event was created.
DATABASE_COLLATION	Database collation with which the event is linked.

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

_{This page is licensed: CC BY-SA / Gnu FDL}