Schedule Database Maintenance Jobs
Schedule backup, vacuum, or analyze jobs with confidence using cron expressions.
(0-59)hour
(0-23)day
(1-31)month
(1-12)weekday
(0-6)
In plain English
At 09:00 on Mon, Tue, Wed, Thu, Fri.
- Thu, May 2809:00
- Fri, May 2909:00
- Mon, Jun 109:00
- Tue, Jun 209:00
- Wed, Jun 309:00
Common patterns
Compatible with standard Unix cron, GitHub Actions, Kubernetes CronJob, and most scheduling systems. Use * for “every”, */5 for “every 5”, 1-5 for ranges, 1,15 for specific values.
Database Jobs tips
PostgreSQL pg_cron, SQL Server Agent, MySQL Event Scheduler — all use cron syntax. The same expression works across them.
For backups: `0 2 * * *` (2am daily) is the conventional choice. Adjust based on your load patterns.
For weekly VACUUM ANALYZE: `0 3 * * 0` (Sunday 3am). Schedules during typical low-traffic times.
ມັນເຮັດວຽກແນວໃດ
ເປັນຫຍັງຕ້ອງໃຊ້ຂອງພວກເຮົາ?
Also check out…
Build Cron for GitHub Actions Workflows
GitHub Actions uses cron syntax for scheduled work
Build Cron for Kubernetes CronJobs
Kubernetes CronJob resources use standard cron syn
Build Cron Entries for Linux crontab
Build expressions for traditional Unix cron (cron,
Learn How Cron Expressions Work
Each tweak shows immediate plain-English explanati
