Table of Contents
Event
Events are tasks that run according to a schedule. When you create an event, you are creating 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. Valentina Studio supports following operations over events:
- List existing events
- Create event
- Drop event
- Modify event
- View detailed information in the Property Inspector
Events are implemented in Valentina and in the MySQL database servers, so the Valentina Studio supports this kind of objects only for listed engines.
Schema Definition
In the Schema Editor notification channels are shown as children of:
- Connection - for Valentina
- Database - for Valentina and MySQL
Events presented in a tree view mode:
Events in the columns view:
Kinds of Events
By relation to database events are distributed to groups:
- Server - events, not bound to any database (supported only by Valentina Server)
- Database - events, executed for specific database
By kind of schedule events can be:
- One-time - executed just once at specified time
- Repeating - executed on the regular basis