Cron Expression for Every Sunday
0 9 * * 00 9 * * 0 runs at 09:00 every Sunday. Sunday is 0 in the weekday field, and most crons accept 7 and the name SUN as equivalents.
Next runs, in your timezone
Sunday is 0 (and usually 7)
POSIX defines both 0 and 7 as Sunday, and Vixie cron accepts the name SUN. All three lines below are the same schedule in standard crontab — but not every scheduler agrees: Quartz numbers days 1–7 starting from Sunday, so double-check ports.
0 9 * * 0 /path/to/job.sh
0 9 * * 7 /path/to/job.sh # same in Vixie cron
0 9 * * SUN /path/to/job.sh # same, by nameWeekly aliases
@weekly is shorthand for 0 0 * * 0 — midnight on Sunday — not for "once every 7 days from now". If the job should run Sunday at a humane hour, write the explicit expression.
Equivalent expressions
0 9 * * 7— same schedule — 7 is also Sunday in Vixie cron@weekly— alias for 0 0 * * 0, midnight on Sunday
Run a SQL query on this schedule
If the job behind this schedule is a database query, you can skip the server and the crontab: SaturnSQL runs saved SQL queries on a cron expression — this exact syntax, with a real timezone field — and delivers the results to Google Sheets or Slack. Minimum interval 5 minutes.