第一種
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;
轉載于:https://www.cnblogs.com/xinxin1994/p/7357617.html