events

The events view displays the information about scheduled tasks created by users in the database. For details, see Table 1. This view is read-only. All users have the read permission on this view, but they can read only the records (schemas) that they have the access permission.

**Table 1** information_schema.events columns
Name	Type	Description
EVENT_CATALOG	varchar(64)	Name of the database in which the job will be executed. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive.
EVENT_SCHEMA	varchar(64)	Name of the schema used for job execution. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive.
EVENT_NAME	varchar(64)	Name of a scheduled task or program.
DEFINER	varchar(93)	Username of the creator.
TIME_ZONE	varchar(64)	Time zone for job scheduling, and the value is system.
EVENT_BODY	varchar(8)	This column is not supported in the current version, and the value is null.
EVENT_DEFINITION	longtext	Job content, which is the program content in the scheduled task.
EVENT_TYPE	varchar(9)	Type of the job. This column is not supported in the current version, and the value is null.
EXECUTE_AT	datetime	Start time of a one-time job.
INTERVAL_VALUE	varchar(256)	Execution interval of a periodic job.
INTERVAL_FIELD	varchar(18)	This column is not supported in the current version, and the value is null.
SQL_MODE	varchar(8192)	SQL mode that takes effect when a job is created or modified. This column is not supported in the current version, and the value is null.
STARTS	datetime	Start time of a periodic job.
ENDS	datetime	End time of a periodic job.
STATUS	varchar(18)	Status of the job. The value is r, s, f, or d. The default value is s. The options are described as follows: r=running s=successfully finished f=job failed d=disabled
ON_COMPLETION	varchar(12)	This column is not supported in the current version, and the value is null.
CREATED	datetime	Time when a job is created. This column is not supported in the current version, and the value is null.
LAST_ALTERED	datetime	Time when a job is last modified. This column is not supported in the current version, and the value is null.
LAST_EXECUTED	datetime	Time when a job was executed last time.
EVENT_COMMENT	varchar(64)	This column is not supported in the current version, and the value is null.
ORIGINATOR	bigint	This column is not supported in the current version, and the value is null.
CHARACTER_SET_CLIENT	varchar(32)	This column is not supported in the current version, and the value is null.
COLLATION_CONNECTION	varchar(32)	This column is not supported in the current version, and the value is null.
DATABASE_COLLATION	varchar(32)	Sequence used by the database.