Event Scheduler Not Taking Effect Immediately After Being Enabled

Scenario

The event scheduler did not take effect immediately after being enabled.

Troubleshooting

1. On the Overview page of the DB instance, check whether Event Scheduler is enabled.

   

2. Check whether the scheduled event is in the ENABLED state.

   show events;

   

3. Check the time zone configured for the instance.

   show variables like "%time_zone%";

   

   

   In the preceding figure, the instance uses UTC time, so the event scheduler, which was configured based on Beijing time, does not take effect immediately.

Solution

Configure the event scheduler based on the time zone of your instance.