15. Event Scheduler
MySQL Event Scheduler lets you run periodic SQL jobs for maintenance, rollups, and cleanup workflows.
Lessons
Scheduling Matrix
| Need | Event schedule |
|---|---|
| One-time execution | AT 'YYYY-MM-DD HH:MM:SS' |
| Repeating job | EVERY 1 HOUR / EVERY 1 DAY |
| Controlled startup | STARTS ... ENDS ... |
What's Next
- Continue to 16. Transactions and Concurrency