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

Task Scheduling

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

Prerequisites

You have logged in to the DAS console.

Procedure

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

    SQL statements must be saved to the database before a scheduling task is created.

  2. In the task list, click Create Task.
  3. In the displayed page, set the required parameters.

    Immediate execution: A scheduled task is executed immediately after being submitted. The task is executed only once.

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

    Periodic execution: After a task is submitted, the task is executed periodically at the specified time.

    Time tolerance: If the expected execution time is exceeded, the scheduled task is not executed again, and the next scheduling is not affected.

  4. Enter and save the SQL statements. Then, submit the task.

    After the 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 View Task Details in the Operation column to view the information about the current scheduled task.

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

      For a periodic task, you can trigger a scheduling immediately. Then, view the execution details on View Scheduling Details page.

    • View Scheduling Details: Allows you to view the task execution details and logs.
    • View Logs: Allows you to view log details.
    • Stop Task: Allows you to stop a scheduled task. The stopped task will be moved to the Finished Tasks list.
    • Suspend Task: Allows you to suspend a task. The task in scheduling will become suspended. You can also restore the task as required.

  6. Click the Finished Tasks tab, view tasks that can be executed immediately or at a scheduled time.

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

    • Click View Task Details in the Operation column to view the information about the current scheduled task.

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

    • View Scheduling Details: Allows you to view the task execution details, group status, SQL content, and group logs.
    • View Logs: Allows you to view log details.
    • Delete Task: Allows you to clear the task information.

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