Recipepythondataetlscripting

Run Python ETL Script

Schedule a Python data processing script with logging.

This cron job runs a Python 3 script and redirects both standard output (stdout) and error output (stderr) to a log file. This is essential for debugging data pipelines (ETL) that run overnight.

Cron Schedule

Every Day at Midnight0 0 * * *

Runs once per day at 00:00 (midnight).

Learn more about Every Day at Midnight

Command to Run

Copy and paste this command into your crontab or automation script

/usr/bin/python3 /path/to/etl_pipeline.py >> /var/log/etl.log 2>&1

This command will run according to the cron schedule above.

Implementation Examples

Here are code examples for implementing this cron job in different programming languages:

Unix/Linux Crontab0 0 * * * /path/to/script.sh

Python (with schedule library)schedule.every().day.at("00:00").do(job)

Node.js (with node-cron)

cron.schedule('0 0 * * *', () => {
  console.log('Running daily at midnight');
});

Go (with robfig/cron)c.AddFunc("0 0 * * *", func() { fmt.Println("Run daily at midnight") })

GitHub Actions Workflow- cron: "0 0 * * *"

Related Cron Recipes

Automate PostgreSQL Backups Daily

How to schedule a daily PostgreSQL database backup using cron.

databasepostgresbackup

View Recipe

Automate MySQL Backups Daily

Schedule a daily MySQL database dump using cron.

databasemysqlbackup

View Recipe

Automate MongoDB Backups Daily

How to schedule a daily MongoDB backup using cron.

databasemongodbbackup

View Recipe

Automate Redis RDB Snapshots

Schedule a Redis background save (snapshot) via cron.

databaserediscache

View Recipe

PostgreSQL Vacuum Analyze

Automate PostgreSQL database maintenance with VACUUM ANALYZE.

databasepostgresmaintenance

View Recipe

Sync Folder to AWS S3

Cron job to sync local files to an AWS S3 bucket.

awscloudbackup

View Recipe