* 160 schedules
Database Backup
* In Plain English
Schedules for automated database dumps, backups, and archival jobs.
* Scheduling Guide
Database backup schedules are among the most critical cron jobs in any production system. The schedule frequency should match your recovery point objective (RPO) — how much data you can afford to lose. Most databases recommend at least a daily full backup with more frequent transaction log or incremental backups in between. Backups should run during the lowest-traffic window to minimise lock contention, and the job should verify the backup by checking file size and running a test restore periodically. Store backups off-site or in a separate cloud region from the primary database; a backup on the same server is lost in a disk failure. Retention policies — how long to keep each backup — should be encoded in the cleanup job that runs after the backup completes.
45 1 1,15 * * Twice a month, on the first and the fifteenth, at 1:45 AM
View details →45 3 1 1 * Once a year, on January first at 3:45 AM
View details →15 0 1 * * Once a month on the first day, at midnight
View details →0 3 * * 5 Every Friday morning at 3 AM
View details →30 0 * * 5 Every Friday at the stroke of midnight
View details →30 19 15 * * Once a month, on the 15th day, at 7:30 in the evening
View details →30 1 * * 1 Every Monday morning at 1:30 AM
View details →30 3 * * 1 Every Monday morning at 3:30 AM
View details →0 0 1 1 * ? Once a year at midnight on January 1st
View details →0 30 22 * * ? Every night at half past ten PM
View details →0 23 * * 6,0 Every Saturday and Sunday evening at 11 PM
View details →15 20 * * 6,0 Every Saturday and Sunday evening at 8:15 PM
View details →0 30 22 ? * 6l Every Saturday at 10:30 PM
View details →0 30 23 ? * 6l Every Saturday evening at 11:30 PM
View details →30 2 * * 5 Every Saturday morning at 2:30 AM
View details →0 45 2 ? * 6l Every Saturday morning at quarter to three
View details →30 22 * * 6,0 Every Saturday and Sunday at half past ten at night
View details →15 23 * * 6,0 Every Saturday and Sunday night at 11:30 PM
View details →0 20 * * 6,0 Every Saturday and Sunday evening at 8 PM
View details →0 30 1 ? * 1#2 On the second Sunday of every month at 1:30 AM
View details →15 23 * * 0 Every Sunday at 11:15 PM
View details →45 1 * * 0 Every Sunday at 1:45 AM
View details →30 1 * * 0 Every Sunday morning at 1:30 AM
View details →30 1 * * 7 Every Sunday at 1:30 AM
View details →Related Topics
Report Generation
Schedules for generating and distributing automated reports and email digests.
1703 schedules
Monthly Schedules
Cron jobs that run once a month, typically for billing, reports, or archival.
980 schedules
Weekly Schedules
Cron jobs that run once a week on a specific day.
564 schedules