System
View, add, and manage scheduled backend jobs. Changes take effect immediately.
Installed Status
sudo /mnt/drive3/customerdb/install_customerdb_cron.sh on the server to refresh the installed file.
Scheduled Jobs
| Job | Schedule | Command | Status | Last Run | |
|---|---|---|---|---|---|
|
Next-Day Customer Emails
Sends pickup reminder emails to customers whose appointment is tomorrow.
|
0 20 * * *
Daily at 20:00
|
php8.3 /mnt/drive3/customerdb/backend/jobs/send_nextday_customer_emails.php |
Disabled
✓ OK |
2026-07-25 00:00 Output[2026-07-24 20:00:01 EDT] Next-day customer email job starting.
Business TZ: America/New_York
Server TZ: UTC
Today: 2026-07-24
Tomorrow: 2026-07-25
Import first: synced tomorrow (2026-07-25) appointments.
fetched=12, visits_created=8, orders_created=8
Raw next-day outreach rows: 15
source customers: 2
source setmore: 12
source visits: 1
Emailable raw rows: 15
Found 15 customer(s) with tomorrow's pickup after dedupe.
→ Kariann Adams <ittybitty6595@yahoo.com> (July 25 2026 9:00 AM) ✓ sent
→ Kelly McCarron <kam67h2p@gmail.com> (July 25 2026 9:30 AM) ✓ sent
→ Olivia Michalski <omichalski00@gmail.com> (July 25 2026 10:00 AM) ✓ sent
→ Leketia D Webb <leketia_bell@yahoo.com> (July 25 2026 10:30 AM) ✓ sent
→ Rose Hoskins <roseb100@hotmail.com> (July 25 2026 10:30 AM) ✓ sent
→ Melissa Favaloro <mommymel8305@gmail.com> (July 25 2026 11:00 AM) ✓ sent
→ Monica Ross <mma3327@yahoo.com> (July 25 2026 11:30 AM) ✓ se
|
|
|
Morning Import
Runs the morning import at 6:00 AM for today.
|
0 6 * * *
Daily at 6:00
|
php8.3 /mnt/drive3/customerdb/backend/jobs/smoke_morning_jobs.php && php8.3 /mnt/drive3/customerdb/backend/jobs/run_morning_jobs.php $(date +\%F) |
Disabled
✓ OK |
2026-07-25 10:00 OutputMorning jobs smoke test passed. Bootstrap and service functions are available. binary=/usr/bin/php8.3 version=8.3.6
{"ok":true,"job_run_id":177,"start_date":"2026-07-25","end_date":"2026-07-25","setmore_sync":{"start_date":"2026-07-25","end_date":"2026-07-25","appointments_fetched":12,"customers_created":0,"visits_created":0,"orders_created":0,"appointments_synced":12,"appointments_skipped_out_of_range":0,"appointments_skipped_placeholder_name":0,"appointments_skipped_missing_identity":0,"appointments_skipped_canceled":0},"daily_totals":[],"appointments":[{"source":"setmore","source_key":"4b6fdd0a-ca2d-4fc6-9c67-3c6a32e89867","start_at":"2026-07-25 16:30:00","end_at":"2026-07-25 17:00:00","status_label":"New","notes":"[New] Drop Off [DB Created]","customer_name":"Krissy Hem","customer_email":"krishem88@gmail.com","customer_phone":"8137740508","customer_id":"495403","visit_id":"129732","order_id":"106868","raw_payload":"{\"key\":\"4b6fdd0a-ca2d-4fc6-9c67-3c6a32e89867\",\"duration\":30,\
|
|
|
Morning Jobs
Runs appointment sync, workflow updates, and morning report generation.
|
0 9 * * *
Daily at 9:00
|
php8.3 /mnt/drive3/customerdb/frontend/api/send_reminders.php |
Disabled | — | |
|
Nightly Reports
Generates and emails nightly summary reports.
|
0 18 * * *
Daily at 18:00
|
php8.3 /mnt/drive3/customerdb/backend/jobs/send_nightly_reports.php |
Disabled
✓ OK |
2026-07-24 22:00 Output{"success":true,"message":"Sent via SMTP (PHPMailer)","to_email":"admin@ellasalterations.com","date":"2026-07-24"}
|
|
|
Database Backup
Full MariaDB backup to backup directory.
|
0 2 * * *
Daily at 2:00
|
bash /mnt/drive3/customerdb/backup.sh |
Disabled
✓ OK |
2026-09-06 06:06 Output[2026-09-06 02:00:01] ── Backup starting ── [2026-09-06 02:00:01] Dumping database ellas_alterations … [2026-09-06 02:00:01] ✓ Database backup: /mnt/drive3/customerdb/backups/db_20260906_020001.sql.gz (41M) [2026-09-06 02:00:01] Archiving app files … [2026-09-06 02:00:01] ✓ Files backup: /mnt/drive3/customerdb/backups/files_20260906_020001.tar.gz (2.4G) [2026-09-06 02:00:01] Archiving PDF reports … [2026-09-06 02:00:01] ✗ Reports backup FAILED [2026-09-06 02:00:01] Removing backups older than 30 days … [2026-09-06 02:00:01] ✓ Backup complete. Total backup storage: 107G [2026-09-06 02:00:01] ── Done ── |
|
|
Daily Cleanup
Removes temp files and old logs.
|
0 4 * * *
Daily at 4:00
|
php8.3 /mnt/drive3/customerdb/backend/jobs/daily_cleanup.php |
Disabled
✓ OK |
2026-09-06 08:00 Output[2026-09-06 08:00:01] Daily cleanup completed. /mnt/drive3/customerdb/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/backend/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/webui/tmp: scanned=0 deleted=0 logs_trimmed=0 cron_job_run_deleted=5 |
|
|
Cleanup Repo Branch Folders
Deletes folders older than 5 days from /mnt/drive3/customerdb_repo/branches using /mnt/drive1/scripts/cleanup_customerdb_branches.sh.
|
20 3 * * *
Daily at 3:20
|
bash /mnt/drive1/scripts/cleanup_customerdb_branches.sh |
Disabled | — | |
|
Add Name Records Auto Delete
Deletes placeholder Add Name customer records that have no visits, orders, payments, phone, or email.
|
20 4 * * *
Daily at 4:20
|
php8.3 /mnt/drive3/customerdb/backend/jobs/delete_add_name_records.php |
Disabled
✓ OK |
2026-07-25 08:20 Output[2026-07-25 08:20:02] Add Name cleanup (orphan mode) starting. Found 0 record(s). [2026-07-25 08:20:02] Done. Deleted 0 Add Name record(s). |
|
|
Report Queue Processor
Processes queued report generation tasks and retries missing receipt/work-order PDFs.
|
5 * * * *
5 * * * *
|
php8.3 /mnt/drive3/customerdb/backend/jobs/process_report_generation_queue.php --limit=300 |
Disabled | — | |
|
Report Missing Backfill (Today)
Hourly repair pass for today's visits to generate missing required reports.
|
10 * * * *
10 * * * *
|
php8.3 /mnt/drive3/customerdb/backend/jobs/backfill_missing_visit_reports.php --days=1 --limit=500 --timeout=70 |
Disabled | — | |
|
Report Missing Alert
Logs/alerts when paid or completed visits are missing required reports.
|
15 * * * *
15 * * * *
|
php8.3 /mnt/drive3/customerdb/backend/jobs/report_alert_missing.php |
Disabled | — | |
|
Report Renderer Health Check
Runs a lightweight PDF renderer health check and stores status.
|
20 * * * *
20 * * * *
|
php8.3 /mnt/drive3/customerdb/backend/jobs/report_renderer_health_check.php |
Disabled | — | |
|
Weekly Report Integrity Export
Exports weekly report completeness CSV for audit/compliance review.
|
0 6 * * 1
Weekly (Mon) at 6:00
|
php8.3 /mnt/drive3/customerdb/backend/jobs/export_weekly_report_integrity.php |
Disabled | — |
sudo cp /tmp/customerdb_crontab_export.txt /etc/cron.d/customerdb && sudo chmod 644 /etc/cron.d/customerdb
The export file is regenerated automatically whenever you save, toggle, or delete a job. Exported jobs now run through the cron wrapper so scheduled runs can log history and send notifications.
Recent Runs
[2026-09-06 08:00:01] Daily cleanup completed. /mnt/drive3/customerdb/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/backend/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/webui/tmp: scanned=0 deleted=0 logs_trimmed=0 cron_job_run_deleted=5
[2026-09-06 02:00:01] ── Backup starting ── [2026-09-06 02:00:01] Dumping database ellas_alterations … [2026-09-06 02:00:01] ✓ Database backup: /mnt/drive3/customerdb/backups/db_20260906_020001.sql.gz (41M) [2026-09-06 02:00:01] Archiving app files … [2026-09-06 02:00:01] ✓ Files backup: /mnt/drive3/customerdb/backups/files_20260906_020001.tar.gz (2.4G) [2026-09-06 02:00:01] Archiving PDF reports … [2026-09-06 02:00:01] ✗ Reports backup FAILED [2026-09-06 02:00:01] Removing backups older than 30 days … [2026-09-06 02:00:01] ✓ Backup complete. Total backup storage: 107G [2026-09-06 02:00:01] ── Done ──
[2026-09-05 08:00:04] Daily cleanup completed. /mnt/drive3/customerdb/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/backend/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/webui/tmp: scanned=0 deleted=0 logs_trimmed=0 cron_job_run_deleted=6
[2026-09-05 02:00:01] ── Backup starting ── [2026-09-05 02:00:01] Dumping database ellas_alterations … [2026-09-05 02:00:01] ✓ Database backup: /mnt/drive3/customerdb/backups/db_20260905_020001.sql.gz (41M) [2026-09-05 02:00:01] Archiving app files … [2026-09-05 02:00:01] ✓ Files backup: /mnt/drive3/customerdb/backups/files_20260905_020001.tar.gz (2.4G) [2026-09-05 02:00:01] Archiving PDF reports … [2026-09-05 02:00:01] ✗ Reports backup FAILED [2026-09-05 02:00:01] Removing backups older than 30 days … [2026-09-05 02:00:01] ✓ Backup complete. Total backup storage: 107G [2026-09-05 02:00:01] ── Done ──
[2026-09-04 08:00:03] Daily cleanup completed. /mnt/drive3/customerdb/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/backend/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/webui/tmp: scanned=0 deleted=0 logs_trimmed=0 cron_job_run_deleted=12
[2026-09-04 02:00:01] ── Backup starting ── [2026-09-04 02:00:01] Dumping database ellas_alterations … [2026-09-04 02:00:01] ✓ Database backup: /mnt/drive3/customerdb/backups/db_20260904_020001.sql.gz (41M) [2026-09-04 02:00:01] Archiving app files … [2026-09-04 02:00:01] ✓ Files backup: /mnt/drive3/customerdb/backups/files_20260904_020001.tar.gz (2.4G) [2026-09-04 02:00:01] Archiving PDF reports … [2026-09-04 02:00:01] ✗ Reports backup FAILED [2026-09-04 02:00:01] Removing backups older than 30 days … [2026-09-04 02:00:01] ✓ Backup complete. Total backup storage: 107G [2026-09-04 02:00:01] ── Done ──
[2026-09-03 02:00:01] ── Backup starting ── [2026-09-03 02:00:01] Dumping database ellas_alterations … [2026-09-03 02:00:01] ✓ Database backup: /mnt/drive3/customerdb/backups/db_20260903_020001.sql.gz (41M) [2026-09-03 02:00:01] Archiving app files … [2026-09-03 02:00:01] ✓ Files backup: /mnt/drive3/customerdb/backups/files_20260903_020001.tar.gz (2.4G) [2026-09-03 02:00:01] Archiving PDF reports … [2026-09-03 02:00:01] ✗ Reports backup FAILED [2026-09-03 02:00:01] Removing backups older than 30 days … [2026-09-03 02:00:01] ✓ Backup complete. Total backup storage: 107G [2026-09-03 02:00:01] ── Done ──
[2026-09-02 08:00:02] Daily cleanup completed. /mnt/drive3/customerdb/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/backend/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/webui/tmp: scanned=0 deleted=0 logs_trimmed=0 cron_job_run_deleted=8
[2026-09-02 02:00:01] ── Backup starting ── [2026-09-02 02:00:01] Dumping database ellas_alterations … [2026-09-02 02:00:01] ✓ Database backup: /mnt/drive3/customerdb/backups/db_20260902_020001.sql.gz (41M) [2026-09-02 02:00:01] Archiving app files … [2026-09-02 02:00:01] ✓ Files backup: /mnt/drive3/customerdb/backups/files_20260902_020001.tar.gz (2.4G) [2026-09-02 02:00:01] Archiving PDF reports … [2026-09-02 02:00:01] ✗ Reports backup FAILED [2026-09-02 02:00:01] Removing backups older than 30 days … [2026-09-02 02:00:01] ✓ Backup complete. Total backup storage: 107G [2026-09-02 02:00:01] ── Done ──
[2026-09-01 08:00:02] Daily cleanup completed. /mnt/drive3/customerdb/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/backend/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/webui/tmp: scanned=0 deleted=0 logs_trimmed=0 cron_job_run_deleted=6
[2026-09-01 02:00:01] ── Backup starting ── [2026-09-01 02:00:01] Dumping database ellas_alterations … [2026-09-01 02:00:01] ✓ Database backup: /mnt/drive3/customerdb/backups/db_20260901_020001.sql.gz (41M) [2026-09-01 02:00:01] Archiving app files … [2026-09-01 02:00:01] ✓ Files backup: /mnt/drive3/customerdb/backups/files_20260901_020001.tar.gz (2.4G) [2026-09-01 02:00:01] Archiving PDF reports … [2026-09-01 02:00:01] ✗ Reports backup FAILED [2026-09-01 02:00:01] Removing backups older than 30 days … [2026-09-01 02:00:01] ✓ Backup complete. Total backup storage: 107G [2026-09-01 02:00:01] ── Done ──
[2026-08-31 08:00:02] Daily cleanup completed. /mnt/drive3/customerdb/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/backend/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/webui/tmp: scanned=0 deleted=0 logs_trimmed=0 cron_job_run_deleted=6
[2026-08-31 02:00:02] ── Backup starting ── [2026-08-31 02:00:02] Dumping database ellas_alterations … [2026-08-31 02:00:02] ✓ Database backup: /mnt/drive3/customerdb/backups/db_20260831_020002.sql.gz (41M) [2026-08-31 02:00:02] Archiving app files … [2026-08-31 02:00:02] ✓ Files backup: /mnt/drive3/customerdb/backups/files_20260831_020002.tar.gz (2.4G) [2026-08-31 02:00:02] Archiving PDF reports … [2026-08-31 02:00:02] ✗ Reports backup FAILED [2026-08-31 02:00:02] Removing backups older than 30 days … [2026-08-31 02:00:02] ✓ Backup complete. Total backup storage: 107G [2026-08-31 02:00:02] ── Done ──
[2026-08-30 08:00:02] Daily cleanup completed. /mnt/drive3/customerdb/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/backend/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/webui/tmp: scanned=0 deleted=0 logs_trimmed=0 cron_job_run_deleted=6
[2026-08-30 02:00:02] ── Backup starting ── [2026-08-30 02:00:02] Dumping database ellas_alterations … [2026-08-30 02:00:02] ✓ Database backup: /mnt/drive3/customerdb/backups/db_20260830_020002.sql.gz (41M) [2026-08-30 02:00:02] Archiving app files … [2026-08-30 02:00:02] ✓ Files backup: /mnt/drive3/customerdb/backups/files_20260830_020002.tar.gz (2.4G) [2026-08-30 02:00:02] Archiving PDF reports … [2026-08-30 02:00:02] ✗ Reports backup FAILED [2026-08-30 02:00:02] Removing backups older than 30 days … [2026-08-30 02:00:02] ✓ Backup complete. Total backup storage: 107G [2026-08-30 02:00:02] ── Done ──
[2026-08-29 08:00:01] Daily cleanup completed. /mnt/drive3/customerdb/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/backend/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/webui/tmp: scanned=0 deleted=0 logs_trimmed=0 cron_job_run_deleted=7
[2026-08-29 02:00:01] ── Backup starting ── [2026-08-29 02:00:01] Dumping database ellas_alterations … [2026-08-29 02:00:01] ✓ Database backup: /mnt/drive3/customerdb/backups/db_20260829_020001.sql.gz (41M) [2026-08-29 02:00:01] Archiving app files … [2026-08-29 02:00:01] ✓ Files backup: /mnt/drive3/customerdb/backups/files_20260829_020001.tar.gz (2.4G) [2026-08-29 02:00:01] Archiving PDF reports … [2026-08-29 02:00:01] ✗ Reports backup FAILED [2026-08-29 02:00:01] Removing backups older than 30 days … [2026-08-29 02:00:01] ✓ Backup complete. Total backup storage: 109G [2026-08-29 02:00:01] ── Done ──
[2026-08-28 08:00:01] Daily cleanup completed. /mnt/drive3/customerdb/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/backend/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/webui/tmp: scanned=0 deleted=0 logs_trimmed=0 cron_job_run_deleted=5
[2026-08-28 02:00:01] ── Backup starting ── [2026-08-28 02:00:01] Dumping database ellas_alterations … [2026-08-28 02:00:01] ✓ Database backup: /mnt/drive3/customerdb/backups/db_20260828_020001.sql.gz (41M) [2026-08-28 02:00:01] Archiving app files … [2026-08-28 02:00:01] ✓ Files backup: /mnt/drive3/customerdb/backups/files_20260828_020001.tar.gz (2.4G) [2026-08-28 02:00:01] Archiving PDF reports … [2026-08-28 02:00:01] ✗ Reports backup FAILED [2026-08-28 02:00:01] Removing backups older than 30 days … [2026-08-28 02:00:01] ✓ Backup complete. Total backup storage: 107G [2026-08-28 02:00:01] ── Done ──
[2026-08-27 08:00:03] Daily cleanup completed. /mnt/drive3/customerdb/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/backend/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/webui/tmp: scanned=0 deleted=0 logs_trimmed=0 cron_job_run_deleted=7
[2026-08-27 02:00:01] ── Backup starting ── [2026-08-27 02:00:01] Dumping database ellas_alterations … [2026-08-27 02:00:01] ✓ Database backup: /mnt/drive3/customerdb/backups/db_20260827_020001.sql.gz (41M) [2026-08-27 02:00:01] Archiving app files … [2026-08-27 02:00:01] ✓ Files backup: /mnt/drive3/customerdb/backups/files_20260827_020001.tar.gz (2.4G) [2026-08-27 02:00:01] Archiving PDF reports … [2026-08-27 02:00:01] ✗ Reports backup FAILED [2026-08-27 02:00:01] Removing backups older than 30 days … [2026-08-27 02:00:01] ✓ Backup complete. Total backup storage: 109G [2026-08-27 02:00:01] ── Done ──
[2026-08-26 08:00:01] Daily cleanup completed. /mnt/drive3/customerdb/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/backend/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/webui/tmp: scanned=0 deleted=0 logs_trimmed=0 cron_job_run_deleted=3
[2026-08-26 02:00:01] ── Backup starting ── [2026-08-26 02:00:01] Dumping database ellas_alterations … [2026-08-26 02:00:01] ✓ Database backup: /mnt/drive3/customerdb/backups/db_20260826_020001.sql.gz (41M) [2026-08-26 02:00:01] Archiving app files … [2026-08-26 02:00:01] ✓ Files backup: /mnt/drive3/customerdb/backups/files_20260826_020001.tar.gz (2.4G) [2026-08-26 02:00:01] Archiving PDF reports … [2026-08-26 02:00:01] ✗ Reports backup FAILED [2026-08-26 02:00:01] Removing backups older than 30 days … [2026-08-26 02:00:01] ✓ Backup complete. Total backup storage: 107G [2026-08-26 02:00:01] ── Done ──
[2026-08-25 08:00:02] Daily cleanup completed. /mnt/drive3/customerdb/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/backend/tmp: scanned=0 deleted=0 /mnt/drive3/customerdb/webui/tmp: scanned=0 deleted=0 logs_trimmed=0 cron_job_run_deleted=3
[2026-08-25 02:00:01] ── Backup starting ── [2026-08-25 02:00:01] Dumping database ellas_alterations … [2026-08-25 02:00:01] ✓ Database backup: /mnt/drive3/customerdb/backups/db_20260825_020001.sql.gz (41M) [2026-08-25 02:00:01] Archiving app files … [2026-08-25 02:00:01] ✓ Files backup: /mnt/drive3/customerdb/backups/files_20260825_020001.tar.gz (2.4G) [2026-08-25 02:00:01] Archiving PDF reports … [2026-08-25 02:00:01] ✗ Reports backup FAILED [2026-08-25 02:00:01] Removing backups older than 30 days … [2026-08-25 02:00:01] ✓ Backup complete. Total backup storage: 109G [2026-08-25 02:00:01] ── Done ──
Add New Job