Help Center > > User Guide> MySQL Database Management> Event Management> Creating an Event

Creating an Event

Updated at: Mar 20, 2020 GMT+08:00

Scenarios

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.

Prerequisites

You have logged in to the DAS console.

Procedure

  1. 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.

  2. Click Save.
  3. In the displayed dialog box, click Execute. If no error is reported, the event takes effect.

Event deletion:

  • 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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel