This content has been marked as final. Show 2 replies
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.
on table ggtest (id varchar2(5), join_date date)
TABLE SHEEL.GGTEST, FILTER (ID="SHEEL"), EVENTACTIONS (ABORT);
TABLE SHEEL.GGTEST, FILTER (JOIN_DATE="31-07-2014"), EVENTACTIONS (ABORT);