Help Center > > User Guide> MySQL DB Instance Management (Development Tool)> Database Management> Event Management> Creating an Event

Creating an Event

Updated at: Jun 09, 2021 GMT+08:00

Scenarios

This section describes how to create an event to periodically respond to specific operations.

When event_scheduler for RDS DB instances is set to ON and the event function is enabled, you can perform operations on events.

When event_scheduler is set to OFF, but the event function is enabled, you can only create events and the events do not take effect.

Procedure

  1. On the top menu bar, choose Database Management. On the displayed Objects page, select Events, and click Create Event.

    Figure 1 Creating an event

  2. Specify an event name (mandatory) and event definition statements (mandatory), set the execution time, status, and comment, and click Create.

    Figure 2 Event details
    • Event Definition Statements

      Indicates the SQL statements to be executed when a scheduled event is triggered.

    • Dropped upon expiration
      • Indicates that the events to be executed at a fixed point in time will be deleted after they are executed.
      • Indicates that the events to be periodically executed will be deleted at the specified end time.

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

    Figure 3 Event script

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