How Do I Create a Scheduled Task for My RDS for MySQL Instance?

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region.
3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Instances page, locate the DB instance and click Log In in the Operation column.

   Alternatively, click the DB instance on the Instances page. On the displayed Basic Information page, click Log In in the upper right corner.

5. Enter the username and password and click Log In.
6. On the top menu bar, choose Background Tasks > Task Scheduling.
7. Click Create Task, enter the task name and execution time tolerance, and set Type to Scheduled.
   • Scheduled: indicates that a task is executed at a scheduled point in time after being submitted. The task is executed only once.
   • 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.

8. Under Add SQL Statements, click Add. On the displayed page, set parameters as needed and click Save. Then, submit the task.