Help Center > > User Guide> GaussDB(for 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

  • Create an event to periodically response to specific operations on databases.
  • When event_scheduler of an RDS DB instance is set to ON, and the event function is enabled, you can manage 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 Editing an event
    • Event Definition Statements

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

    • Dropped upon expiration

      Indicates that the event to be executed at a fixed time will be deleted after it is executed and the event to be executed in a scheduled cycle will be deleted at the specified 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