大神帮忙看看啊
代码
begin
sys.dbms_job.submit(job => :job,
what => '-- 处理交换接受的数据,每天01:00:00 执行一次
pack_jc_control.PROC_DEAL_TIMELIMIT_ALLNOBJ;',
next_date => to_date('01-01-4000', 'dd-mm-yyyy'),
interval => 'trunc(sysdate+1)');
sys.dbms_job.broken(job => :job,
broken => true,
next_date => to_date('01-01-4000', 'dd-mm-yyyy'));
commit;
end;
/