Help Center > > User Guide> MySQL Database Management (Standard Edition)> 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.

When you set the value of the event_scheduler parameter to ON and the event function is enabled, you can perform operations on events.

When you set the value of the event_scheduler parameter to OFF and the event function is enabled, the event cannot take effect.

Prerequisites

You have logged in to the DAS console.

Procedure

  1. On the top menu bar, choose Database Management. In the navigation pane on the left, choose Events > Create Event.
  2. Enter the event name (mandatory) and event definition statement (mandatory), set the event execution time, status, and comment, and click Create.

    • Event definition statements

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

    • Delete expired events

      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.

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

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