I have a few jobs that are routinely reloaded based on the previous one succeeding (using the inbuilt scheduler) - and have been working fine for weeks.
However, last week one part of the chain stopped working. It just doesn't execute any more.
I've tried deleting and recreating the schedule, but still nothing.
Any pointers?
The task chain is basically:
1 -- ILE_Production (Timed)
2 -- StaticData (Dependent on the above succeeding)
3 -- VE_Production_Consumption (Dependent on the above succeeding)
4 -- production-variance-finance-extract (Based on above succeeding) This is the one that doesn't run
5 -- Production Variance (triggered by above succeeding)
6 -- Production Variance QVD Generation (triggered by above succeeding)
ve_production_consumption
running daily as expected:
production-variance-finance-extract (the job that's not running) - last run is not populated as I rebuilt the schedule in the hope it fixes it.
was running, and just stopped?
However, the dependent task is 100% returning SUCCEEDED status