Request For Support To Create DB JOB For ETL Auto Scheduling Twice A Day
Last updated on APRIL 20, 2015
Applies to:Oracle Argus Insight - Version 7.0.3 and later
Information in this document applies to any platform.
For one of the customer the auto schedule ETL functionality is not working. It is confirmed as a BUG. Ref: Bug 18364180 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=18364180] - Argus Insight 22.214.171.124 - automatic ETL not working.
So as a temporary work around, we created DB Job to run ETL daily once. However, customer requested to run it twice daily (3AM GMT and 3PM GMT). We need to modify the DB job script to run it twice daily (3AM and 3PM GMT). Would you kindly help us in modifying the DB Job Script.
Here is the script we used to run ETL Daily once:
( job => X
,what => 'begin pkg_dbms_job.p_call_air_incremental(1); end;'
,next_date => to_date('08/04/2015 13:30:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'TRUNC(SYSDATE+1) + (13.5/24)'
,no_parse => FALSE
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
SET VALUE = TO_CHAR(x)
WHERE KEY = '10'
AND UPPER(NAME) = 'ETL_JOB_ID';
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms