Checking sc7 for 2026-09-18
Fixed deleted job 6049147.sc7pbs-01-ib: end_time NULL -> 2026-09-18 15:20:20, reason 25 -> 28
✅ All expected job-date pairs are present in the database (±2 day tolerance).

Checking sc8 for 2026-09-18
Could not find a matching job row for deleted job 5898328.sc8pbs-01-ib
Could not find a matching job row for deleted job 5898329.sc8pbs-01-ib
Could not find a matching job row for deleted job 5898330.sc8pbs-01-ib
Could not find a matching job row for deleted job 5898331.sc8pbs-01-ib
Could not find a matching job row for deleted job 5898332.sc8pbs-01-ib
Could not find a matching job row for deleted job 5898333.sc8pbs-01-ib
Fixed deleted job 5930390.sc8pbs-01-ib: end_time NULL -> 2026-09-18 14:21:27, reason 25 -> 28
Fixed deleted job 5930391.sc8pbs-01-ib: end_time NULL -> 2026-09-18 14:21:27, reason 25 -> 28
Fixed deleted job 5936473.sc8pbs-01-ib: end_time NULL -> 2026-09-18 20:16:59, reason 25 -> 28
Fixed deleted job 5936458.sc8pbs-01-ib: end_time NULL -> 2026-09-18 20:16:59, reason 25 -> 28
Fixed deleted job 5936800.sc8pbs-01-ib: end_time NULL -> 2026-09-18 21:08:51, reason 25 -> 28
Fixed deleted job 5936776.sc8pbs-01-ib: end_time NULL -> 2026-09-18 21:08:51, reason 25 -> 28

❌ Missing job entries (±2 day tolerance):
2026-09-18 00:31:26 — 5898328.sc8pbs-01-ib (expected in end_time)
2026-09-18 00:31:26 — 5898329.sc8pbs-01-ib (expected in end_time)
2026-09-18 00:31:26 — 5898330.sc8pbs-01-ib (expected in end_time)
2026-09-18 00:31:26 — 5898331.sc8pbs-01-ib (expected in end_time)
2026-09-18 00:31:26 — 5898332.sc8pbs-01-ib (expected in end_time)
2026-09-18 00:31:26 — 5898333.sc8pbs-01-ib (expected in end_time)

Attempting to fix missing job entries...

🔁 Re-checking for missing jobs after fix...
Could not find a matching job row for deleted job 5898328.sc8pbs-01-ib
Could not find a matching job row for deleted job 5898329.sc8pbs-01-ib
Could not find a matching job row for deleted job 5898330.sc8pbs-01-ib
Could not find a matching job row for deleted job 5898331.sc8pbs-01-ib
Could not find a matching job row for deleted job 5898332.sc8pbs-01-ib
Could not find a matching job row for deleted job 5898333.sc8pbs-01-ib

❌ Missing job entries (±2 day tolerance):
2026-09-18 00:31:26 — 5898328.sc8pbs-01-ib (expected in end_time)
2026-09-18 00:31:26 — 5898329.sc8pbs-01-ib (expected in end_time)
2026-09-18 00:31:26 — 5898330.sc8pbs-01-ib (expected in end_time)
2026-09-18 00:31:26 — 5898331.sc8pbs-01-ib (expected in end_time)
2026-09-18 00:31:26 — 5898332.sc8pbs-01-ib (expected in end_time)
2026-09-18 00:31:26 — 5898333.sc8pbs-01-ib (expected in end_time)
❌ Some entries are still missing after attempted fixes.