第一种
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://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLicmbw5SM2cTM5QzN1ETMtEjMwUjM5ADNxQTM4AzNxAjMtUjNwQzM48CX4AzNxAjMvwVN2ADNzgzLcd2bsJ2Lc12bj5ycn9Gbi52YucTMwIzcldWYtl2Lc9CX6MHc0RHaiojIsJye.png)
转载于:https://www.cnblogs.com/xinxin1994/p/7357617.html