Cron Expression: 15th of Every Month at Midnight (0 0 15 * *)

The cron expression 0 0 15 * * executes a task on the 15th of every month at midnight (00:00), making it ideal for mid-month operations, reports, and tasks that should run halfway through each month.

Expression Breakdown

bash

0 0 15 * *
│ │ │ │ │
│ │ │ │ └─── Day of week: * (every day)
│ │ │ └───── Month: * (every month)
│ │ └─────── Day of month: 15 (15th day)
│ └───────── Hour: 0 (at hour 0, midnight)
└─────────── Minute: 0 (at minute 0)

Field Values

Field	Value	Meaning
Minute	`0`	At minute 0
Hour	`0`	At hour 0 (midnight)
Day of Month	`15`	15th day of month
Month	`*`	Every month (1-12)
Day of Week	`*`	Every day of week (0-7)

Execution Time

This expression runs once per month at:

15th of every month at 00:00 (midnight)

Common Use Cases

1. Mid-Month Reports

bash

0 0 15 * * /usr/bin/python3 /scripts/generate-mid-month-report.py

Generate mid-month reports or status updates.

2. Mid-Month Billing

bash

0 0 15 * * /usr/bin/python3 /scripts/process-mid-month-billing.py

Process mid-month billing cycles or partial invoices.

3. Mid-Month Backups

bash

0 0 15 * * /usr/local/bin/mid-month-backup.sh

Create mid-month backups or snapshots.

4. Mid-Month Maintenance

bash

0 0 15 * * /usr/local/bin/mid-month-maintenance.sh

Run mid-month maintenance, cleanup, or optimization tasks.

Example Implementations

Mid-Month Report Script

python

# generate-mid-month-report.py
import json
from datetime import datetime
import sqlite3

def generate_mid_month_report():
    conn = sqlite3.connect('/var/data/app.db')
    cursor = conn.cursor()
    
    # Get data from first half of month
    today = datetime.now()
    first_day = today.replace(day=1)
    
    cursor.execute('''
        SELECT 
            COUNT(*) as total_transactions,
            SUM(amount) as total_revenue,
            COUNT(DISTINCT user_id) as unique_customers
        FROM transactions
        WHERE created_at >= ? AND created_at < ?
    ''', (first_day, today))
    
    metrics = cursor.fetchone()
    
    report = {
        'month': today.strftime('%Y-%m'),
        'period': 'first_half',
        'date': today.strftime('%Y-%m-%d'),
        'metrics': {
            'total_transactions': metrics[0],
            'total_revenue': round(metrics[1], 2) if metrics[1] else 0,
            'unique_customers': metrics[2]
        }
    }
    
    with open(f'/var/reports/mid_month_{today.strftime("%Y%m")}.json', 'w') as f:
        json.dump(report, f, indent=2)
    
    print(f"{datetime.now()}: Mid-month report generated")
    conn.close()

if __name__ == '__main__':
    generate_mid_month_report()

Best Practices

Mid-Month Timing: 15th provides a good midpoint for monthly operations
Error Handling: Implement comprehensive error handling and logging
Locking: Use file locks to prevent concurrent execution
Monitoring: Set up alerts for failed monthly jobs
Resource Management: Monitor system resources during execution

When to Use

✅ Good for:

Mid-month reports
Mid-month billing
Mid-month backups
Mid-month maintenance
Mid-month data processing

❌ Avoid for:

Tasks requiring more frequent execution
Real-time critical operations

Related Patterns

Pattern	Expression	Description
First day of month	`0 0 1 * *`	Start of month
15th of month	`0 0 15 * *`	Mid-month
Last day workaround	`59 23 28-31 * *`	End of month (requires script)

Conclusion

The 0 0 15 * * expression is perfect for mid-month operations. It's commonly used for mid-month reports, billing cycles, and maintenance tasks, providing a midpoint check on monthly operations.

Cron Expression: 15th of Every Month at Midnight (0 0 15 * *)

Need to generate a cron expression?

Cron Expression: 15th of Every Month at Midnight (0 0 15 * *)

Expression Breakdown

Field Values

Execution Time

Common Use Cases

1. Mid-Month Reports

2. Mid-Month Billing

3. Mid-Month Backups

4. Mid-Month Maintenance

Example Implementations

Mid-Month Report Script

Best Practices

When to Use

Related Patterns

Conclusion

Need to generate a cron expression?