SHOW EVENTS

[NEW in 3.0]

The SHOW EVENTS statement is used to list events of the Scheduler of a Valentina Server. Result of this statement is Cursor as with SELECT statement.

SHOW EVENTS {FROM|OF} db_name 

fld_name

The name of the event.

fld_enabled

The event status. One of ‘ENABLED’ or ‘DISABLED’.

fld_preserve_on_completion

Is keep the event after it expired, or drop it.

fld_action

The sql statement used when event is fired.

fld_comment

The description of event.

fld_created

The created date and time for a event.

fld_modified

The modified date and time for a event.

fld_last_executed

The date and time of last executed for a event.

fld_execute_at

The date and time when a transient event is set to execute. Shown as a DATETIME value.

For a recurring event, the value of this column is always NULL

fld_interval_value

The value of date time unit.

fld_interval_unit

The type date time unit.

fld_starts

The start date and time for a recurring event. This is displayed as a DATETIME value, and is empty if STARTS value is not defined for the event.

For a transient event, the value of this column is always NULL.

fld_ends

The end date and time for a recurring event. This is displayed as a DATETIME value, and is empty if ENDS value is not defined for the event.

For a transient event, the value of this column is always NULL.

• Before execute this command you must switch active database to be masterdb, for this you need use SQL command “USE master;”