一小时执行一次存储过程

第一种

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;