第一种
declare job7 NUMBER; begin sys.dbms_job.submit (job =>job7, what =>'UPDATEMAGNETICBROKEN;', next_date => SYSDATE, interval => 'SYSDATE + 60 / (24*60)'); commit; end;
第二种
declare job NUMBER; BEGIN SYS.DBMS_JOB.SUBMIT(JOB => JOB, WHAT => 'begin UPDATEMAGNETICBROKEN; end;', NEXT_DATE => TO_DATE('14-08-2017', 'dd-mm-yyyy'), INTERVAL => 'TRUNC(SYSDATE + 1)+1/24'); COMMIT; END;