Help Center > > User Guide> MySQL DB Instance Management (Standard Edition)> Task Scheduling

Task Scheduling

Updated at: Sep 29, 2020 GMT+08:00

Prerequisites

You have logged in to a MySQL DB instance on the DAS console.

Procedure

  1. On the top menu bar, choose Background Tasks > Task Scheduling.

    You can create a scheduling task only after agreeing to save the SQL statements in the database.

  2. On the Scheduling Tasks page, click Create Task.
  3. On the displayed page, set the task name, scheduling type, and execution time tolerance.

    Upon submission: Indicates that a scheduled task is executed immediately after being submitted. The task is executed only once.

    Scheduled: Indicates that a task is executed at a scheduled point in time after being submitted. The task is executed only once.

    Periodic: Indicates that a task is executed periodically at the specified time after being submitted.

    Execution Time Tolerance: Indicates the length of time (in seconds) to wait for a task to be executed before it is no longer scheduled. However, this will not affect the task if it is scheduled again later.

  4. Under Add SQL Statements, click Add. In the displayed dialog box, set required parameters as required and click Save. Then, submit the task.

    After a task is executed, it is automatically displayed in the list of finished tasks.

  5. In the task list, view the scheduling type of the task.

    You can search for tasks by status, scheduling type, task ID, or task name.

    • Click Details in the Operation column to view the task information.

      Obtain the execution logs and group details from the group list and view the SQL content.

      Click the task name that is periodically scheduled to go to the Task Information page. Then, click Schedule Now to trigger a scheduling immediately. Additionally, view the execution details on the Scheduling Execution Records tab page.

    • Execution Details: Click it to view the task execution details and logs.
    • View Logs: Click it to view log details.
    • Terminate: Click it to stop a scheduled task. A stopped task will be moved to the Finished Tasks list.
    • Pause: Click it to pause a task. The task in scheduling will become paused. You can also restore the task as required.

  6. On the Finished Tasks page, view tasks that can be executed upon submission or at a scheduled point in time.

    You can search for tasks by status, scheduling type, task ID, or task name.

    • Click Details in the Operation column to view the task information.

      Obtain the execution logs and group details from the group list and view or modify the SQL statement list.

    • Click Execution Records in the Operation column to view the task execution details, group status, SQL content, and group logs.
    • Click View Logs in the Operation column to view log details.
    • Click Delete in the Operation column to delete selected tasks from a database.

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