cron0 3 * * *

dbt Daily Run — 3 AM

“At 03:00”

Executes the full dbt model DAG every day at 3 AM. Runs all dbt models in dependency order, tests data quality assertions, and generates documentation for changed models.

Daily1 run/day

Want to customize this schedule or validate your own cron expression?

Try it live →

Field Breakdown

Field	Value	Meaning
minute	`0`	0
hour	`3`	3
day	`*`	every day of month
month	`*`	every month
weekday	`*`	every day of week

minute

hour

day

month

weekday

Lint Analysis

Info

This time may fall within a DST transition gap for some timezones. Jobs could be skipped or run twice.

Common Use Cases

✓dbt daily run cron
✓dbt model refresh 3am scheduler
✓Data warehouse transformation daily
✓Analytics engineering pipeline cron

Code Examples

Bash / crontab

# Run your script on schedule: 0 3 * * *
0 3 * * * /path/to/your/script.sh

Node.js (node-cron)

import cron from 'node-cron';

cron.schedule('0 3 * * *', () => {
  console.log('Running scheduled task');
});

Python (APScheduler)

from apscheduler.schedulers.blocking import BlockingScheduler

scheduler = BlockingScheduler()

@scheduler.scheduled_job('cron', minute='0', hour='3')
def my_job():
    print('Running scheduled task')

scheduler.start()

GitHub Actions Workflow

Generate a ready-to-use .github/workflows/schedule.yml file. Customize the name and download directly.

GitHub Actions

Workflow Name

Job ID

# .github/workflows/schedule.yml
name: dbt Daily Run — 3 AM

on:
  schedule:
    - cron: '0 3 * * *'
  workflow_dispatch: # allow manual trigger

jobs:
  run:
    runs-on: ubuntu-latest
    steps:
      - name: Checkout code
        uses: actions/checkout@v4

      - name: Run scheduled task
        run: |
          echo "Running on schedule: 0 3 * * *"
          # Add your commands here

Save as .github/workflows/schedule.yml in your repository root

Cron Syntax Quick Reference

Field	Allowed Values	Special Chars
minute	0–59	* , - /
hour	0–23	* , - /
day of month	1–31	* , - /
month	1–12 or JAN–DEC	* , - /
day of week	0–7 or SUN–SAT	* , - /

Special characters: *= any value ,= list -= range / = step

Related Patterns — Daily

0 0 * * *

Daily at Midnight (00:00)

Need to build your own cron expression from scratch?

Open the Cron Expression Builder →