2 Replies Latest reply: Aug 11, 2014 7:40 AM by 960104 RSS

    How to stop or abort an extract using eventactions

    Dhairyasheel-Oracle

      HI

      The requirement is that as soon as sysdate is entered in the EOD_JOB_STATUS table's  op_date field, the extract fetching this table, along with a few others, should abort.

       

      I have even tried aborting extract based on literal values like 'SHEEL' but the extract just keeps running and when we fire stats extract_name it does not show any record.

       

      sample extract

       

      on table ggtest (id varchar2(5), join_date date)

       

      extract evtest

      userid ......

      extrrail.....

      GETUPDATEBEFORES

      TABLE SHEEL.GGTEST, FILTER (ID="SHEEL"), EVENTACTIONS (ABORT);

       

      2ND EXAMPLE

       

      extract evtest

      userid ......

      extrrail.....

      GETUPDATEBEFORES

      TABLE SHEEL.GGTEST, FILTER (JOIN_DATE="31-07-2014"), EVENTACTIONS (ABORT);

       

      Best Regards

      Dhairyasheel