Run Jobs on the Last Day of the Month | CronBase

// Node.js implementation using standard cron pattern.
// Since many Node libraries lack native 'L' support, we schedule
// daily for the end of the month and evaluate programmatically.
const cron = require('node-cron');

function isLastDayOfMonth() {
    const today = new Date();
    const tomorrow = new Date(today);
    tomorrow.setDate(today.getDate() + 1);
    return tomorrow.getDate() === 1;
}

// Runs daily at midnight from the 28th to the 31st
cron.schedule('0 0 28-31 * *', () => {
    if (!isLastDayOfMonth()) {
        return;
    }
    console.log('Executing end-of-month database reconciliation...');
    try {
        // Execute production business logic here
    } catch (error) {
        console.error('Failed to run monthly job:', error);
    }
});

#!/usr/bin/env bash
# Since standard Linux cron doesn't natively support 'L',
# schedule this script to run daily (0 0 28-31 * *), and
# this guard clause will ensure the payload only runs on the last day.
set -euo pipefail

TOMORROW=$(date -d "tomorrow" +%d)
if [ "$TOMORROW" -ne 1 ]; then
    echo "Today is not the last day of the month. Exiting."
    exit 0
fi

echo "Starting end-of-month maintenance tasks..."
# Call your production payload here
# /opt/bin/run-billing-aggregation.sh

# Python script designed to run daily on days 28-31.
# It checks if today is the last day of the month before executing.
import datetime
import sys

def is_last_day_of_month():
    today = datetime.date.today()
    tomorrow = today + datetime.timedelta(days=1)
    return tomorrow.day == 1

def run_monthly_pipeline():
    if not is_last_day_of_month():
        print("Skipping: Today is not the last day of the month.")
        sys.exit(0)
    
    print("Starting monthly data pipeline...")
    try:
        # Insert production database aggregation code here
        pass
    except Exception as e:
        print(f"Error executing monthly pipeline: {e}")
        sys.exit(1)

if __name__ == "__main__":
    run_monthly_pipeline()

package main

import (
	"fmt"
	"time"
)

// IsLastDayOfMonth checks if the current time is on the last day of its month.
func IsLastDayOfMonth(t time.Time) bool {
	tomorrow := t.AddDate(0, 0, 1)
	return tomorrow.Day() == 1
}

func main() {
	// In Go, standard cron libraries like robfig/cron require manual guards
	// if scheduled with generic patterns, or custom Spec parsers.
	now := time.Now().UTC()
	if !IsLastDayOfMonth(now) {
		fmt.Println("Not the last day of the month. Skipping execution.")
		return
	}

	fmt.Println("Executing monthly ledger closeout process...")
	// Place production execution logic here
}

import org.quartz.CronScheduleBuilder;
import org.quartz.Trigger;
import org.quartz.TriggerBuilder;
import org.quartz.JobDetail;
import org.quartz.JobBuilder;
import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

// Quartz natively supports the 'L' character for Last Day of Month.
public class MonthlyBillingJob implements Job {
    @Override
    public void execute(JobExecutionContext context) throws JobExecutionException {
        System.out.println("Executing Quartz monthly billing run...");
        // Implement production billing logic here
    }

    public static void main(String[] args) {
        JobDetail job = JobBuilder.newJob(MonthlyBillingJob.class)
            .withIdentity("monthlyBillingJob", "group1")
            .build();

        // "0 0 0 L * ?" is Quartz syntax for midnight on the last day of the month
        Trigger trigger = TriggerBuilder.newTrigger()
            .withIdentity("monthlyBillingTrigger", "group1")
            .withSchedule(CronScheduleBuilder.cronSchedule("0 0 0 L * ?"))
            .build();
    }
}

apiVersion: batch/v1
kind: CronJob
metadata:
  name: monthly-cleanup-job
  namespace: production
spec:
  # Kubernetes CronJob uses standard Go cron which does not support 'L'.
  # We schedule for midnight on days 28-31 and use a shell wrapper to check.
  schedule: "0 0 28-31 * *"
  concurrencyPolicy: Forbid
  successfulJobsHistoryLimit: 3
  failedJobsHistoryLimit: 5
  jobTemplate:
    spec:
      template:
        spec:
          containers:
          - name: worker
            image: alpine:3.18
            command:
            - /bin/sh
            - -c
            - |
              TOMORROW=$(date -d "tomorrow" +%d)
              if [ "$TOMORROW" -ne 1 ]; then
                echo "Not the last day of the month. Exiting."
                exit 0
              fi
              echo "Starting monthly maintenance..."
              # Run production payload here
          restartPolicy: OnFailure