Switch to: V9V8V7V6V5

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.

Syntax

SHOW EVENTS [{FROM|OF} db_name]

Arguments

db_name

Specifies the name of database for which you want get events.

Starting from v6.2 you can:

  • Specify empty string, to select events created on servel-level, i.e. events which are independent of any database.
  • Specify only “SHOW EVENTS”. In this case you will get list of all events under VServer with additional column that contains the name to which event belongs, or empty string if it belongs to server-level.

Result Columns

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.

fld_next_execution

The date and time of next execution for a event.

Notes

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