SQL> variable jobno number
SQL> begin dbms_job.submit(job => :jobno,what => 'BEGIN MES_PROC_FVI_CKVAL; END;',next_date => sysdate,interval => 'SYSDATE+1/24'); end;
2 /
PL/SQL procedure successfully completed
jobno
---------
127
SQL> commit;
Commit complete
沒有留言:
張貼留言