1 Reply Latest reply: Dec 15, 2014 3:00 PM by Massimo Grossi RSS

    Scheduled task should fail,if data-warehouse reload fails

    swarup malli

      Hi,

       

       

      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?