有参版
declare
job_id number(2);
begin
sys.dbms_job.submit(job => job_id,
what => 'declare
cl_start_date varchar2(100);
cl_end_date varchar2(100);
p_success varchar2(4000);
p_msg varchar2(4000);
begin
P_DP_HN_DATE(
p_cl_start_date => cl_start_date,
p_cl_end_date => cl_end_date,
p_success => p_success,
p_msg => p_msg
);end;',
NEXT_DATE => TRUNC(SYSDATE + 1) + 18 / 24,
INTERVAL => 'TRUNC(next_day(sysdate,1))+2/24');
commit;
end;
无参版
declare
job_id number(2);
begin
sys.dbms_job.submit(job => job_id,
what => 'P_DP_HN_DATE;',
NEXT_DATE => TRUNC(SYSDATE + 1) + 18/24,
INTERVAL => 'TRUNC(next_day(sysdate,1))+2/24'
);
commit;
end;
参数解释
NEXT_DATE :下一次执行时间
INTERVAL :定义时间间隔
what :指定作业(job)类型和相关参数
TRUNC(SYSDATE + 1) + 18/24:计算当前日期的下一天,并将时间截断到当天的18点
TRUNC(next_day(sysdate,1))+2/24:计算当前日期的下一个星期一的凌晨2点