Schedule Database Maintenance Jobs

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

Hakuna kuingia kinachohitajika

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.

Jinsi Inavyofanya Kazi

Ingiza

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

Chakata

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

Pakua

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

Kwa nini utumie yetu?

✓Bure kabisa — bila gharama zilizofichwa, kamwe

✓Hakuna akaunti, barua pepe, au kuingia kinachohitajika

✓Faili hazitoki kwenye kifaa chako kamwe

✓Hakuna kikwazo cha ukubwa wa faili kabisa

✓Hakuna alama za maji kwenye matokeo yoyote

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

Maswali Yanayoulizwa Mara Kwa Mara

Back to Cron Expression Builder