declare
jobno number;
begin
sys.dbms_job.submit(job=>jobno,
what=>'ori_bon.sp_bill_clear_day;',
next_date=>sysdate,
interval=>'sysdate+1+(6*60+5)/(24*60)'
);
end;
折腾大半天啊,网上能搜到的都是jobno前面带个封号的,挺害人啊
declare
jobno number;
begin
sys.dbms_job.submit(job=>jobno,
what=>'ori_bon.sp_bill_clear_day;',
next_date=>sysdate,
interval=>'sysdate+1+(6*60+5)/(24*60)'
);
end;