Online Documentation for SQL Manager for MySQL
MySQL Events are tasks that run according to a schedule. Therefore, they are often referred to as Scheduled events. In fact, an event is a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Conceptually, this is similar to the idea of the Unix crontab (also known as a "cron job") or the Windows Task Scheduler.
Scheduled tasks of this type are also sometimes known as "temporal triggers", implying that these are objects that are triggered by the passage of time. Events should more specifically not be confused with "temporary triggers". Whereas a trigger is a database object whose statements are executed in response to a specific type of event that occurs on a given table, a scheduled event is an object whose statements are executed in response to the passage of a specified time interval.
Scheduled Event Editor allows you to define scheduled event properties. It opens automatically when you create a new scheduled event and is available on editing an existing one.
To open a scheduled event in Scheduled Event Editor, double-click it in the DB Explorer tree.
- Using Navigation bar and Toolbar
- Creating/editing scheduled event
- Browsing object dependencies
- Editing event description
- Viewing DDL definition