Schedule Database Maintenance Jobs

Schedule backup, vacuum, or analyze jobs with confidence using cron expressions.

Nid oes angen mewngofnodi

Cron expression

minute
(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.

Next 5 scheduled runs (your local time)

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.

Sut Mae'n Gweithio

Ewch i mewn

Enter your data into the tool above. Everything stays local to your browser.

Proses

The tool processes your data instantly in your browser using JavaScript. No server, no waiting.

Lawrlwythwch

Get your result instantly. Nothing is stored after you leave the page — complete privacy.

Pam defnyddio ein un ni?

✓Hollol rhad ac am ddim - dim costau cudd, byth

✓Nid oes angen cyfrif, e-bost na mewngofnodi

✓Nid yw ffeiliau byth yn gadael eich dyfais

✓Dim cyfyngiadau maint ffeil o gwbl

✓Dim dyfrnodau ar unrhyw allbwn

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

Cwestiynau Cyffredin

Back to Cron Expression Builder