Event Scheduler Not Taking Effect Immediately After Being Enabled
Scenario
The event scheduler did not take effect immediately after being enabled.
Troubleshooting
- On the Basic Information page, check whether Event Scheduler is enabled.
- Check whether the scheduled event is in the ENABLED state.
show events;
- Check the time zone configured for the instance.
show variables like "%time_zone%";
Solution
Configure the event scheduler based on the time zone of your instance.
Parent topic: SQL Issues
- Scenario
- Troubleshooting
- Solution