Creating an Event
This section describes how to create an event to periodically respond to specific events of MySQL databases.
When the event_scheduler parameter in RDS is set to ON and the event is in the enabled state, event management operations are supported. When event_scheduler is set to OFF, you can create an event but the event will not take effect event though it is in the enabled state.
You have logged in to the DAS console.
- In the navigation tree on the left, right-click Events under the target database and choose Create Event from the shortcut menu.
- You need to specify the event information, including the event name, status, execution time (for example, the fixed time or the start and end time in a period), and comment.
- In addition, you need to enter SQL statements in the Event Definition Statement area to define the operation that needs to be performed when the event is triggered at a scheduled time.
- Click Save.
- In the displayed dialog box, click Execute. If no error is reported, the event takes effect.
- The event to be executed at a fixed time will be deleted after it is executed.
- The event to be executed in a periodic time will be deleted at the specified end time.