begin
sys.dbms_job.submit(job => :job,
what => 'PSMS_CHECKMAIN;',
next_date => to_date('19-09-2003 18:00:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'trunc(sysdate,''hh24'')+1/24*60');
commit;
end;--注意下面的语句
SYSDATE + 1/24*60
每分钟执行一次
sys.dbms_job.submit(job => :job,
what => 'PSMS_CHECKMAIN;',
next_date => to_date('19-09-2003 18:00:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'trunc(sysdate,''hh24'')+1/24*60');
commit;
end;--注意下面的语句
SYSDATE + 1/24*60
每分钟执行一次
jobnum number;
dbms_job.submit(jobnum,'pro;',sysdate,'sysdate+1/(24*60)');
commit;
end;
/