每天临晨执行的任务：
declare
jobnum integer;
begin
dbms_job.submit(
job=>jobnum,
what=>'gentTmpdate2;',
next_date=>trunc(sysdate)+23.9/24,
interval=>'trunc(sysdate+1)+23.9/24'
);
commit;
end;
每月最后一天临晨执行的任务：
declare
jobnum integer;
begin
dbms_job.submit(
job=>jobnum,
what=>'sp_invoice_zz;',
next_date=>trunc(last_day(sysdate))+23.9/24,
interval=>'trunc(last_day(add_months(sysdate,1)))+23.9/24'
);
commit;
end;
/
Trackback: http://tb.donews.net/TrackBack.aspx?PostId=1095365