–设置判断条件调用作业流
begin
sys.dbms_scheduler.create_job(job_name => ‘’,
job_type => ‘PLSQL_BLOCK’,
job_action => ‘DECLARE
LVC_BZ NUMBER;
O_SUCC_FLAG VARCHAR(1);
O_SHELL_FLAG VARCHAR(1);
I_BATCH_ID NUMBER(10);
BEGIN
SELECT TO_CHAR(SYSDATE, ‘‘D’’) INTO LVC_BZ FROM DUAL;
IF LVC_BZ <> 6 THEN
BEGIN
PKG_ETL_SHELL.P_ETL_SHELL_FLOW2(’’’’, NULL, NULL);
END;
ELSE
NULL;
END IF;
END;’,
start_date => to_date(‘22-12-2019 20:00:00’, ‘dd-mm-yyyy hh24:mi:ss’),
repeat_interval => ‘Freq=Daily;Interval=1;ByHour=20;ByMinute=00;BySecond=00’,
end_date => to_date(null),
job_class => ‘DEFAULT_JOB_CLASS’,
enabled => true,
auto_drop => false,
comments => ‘’);
end;
/
–定时杀死作业流
begin
sys.dbms_scheduler.create_job(job_name => ‘’,
job_