We use wherescape to reload dims and facts of the data warehouse .
The QMC tasks are triggers at a certain time everyday. These jobs are not triggered after data warehouse (DW) are reloaded successfully.
I had scheduled the QMC tasks with the hope that DW gets reloaded successfully by wherescape 10 mins before the QMC task starts.
Now there are times when the Wherscape job fails,but QMC still executes the task as its not triggered by an external event.
Is there a way I can trigger QMC ONLY after the reload of DW has been successfully completed/failed by Wherescape ?
i.e trigger QMC task after an external event?