turtle

DECLARE    JOBNO   NUMBER; BEGIN    DBMS_JOB.SUBMIT       (JOB  => JOBNO       ,WHAT => 'BEGIN PROCEDURE_NAME; END;'       ,NEXT_DATE => SYSDATE       ,INTERVAL  => 'SYSDATE+365');    COMMIT; END; DBMS_JOB.submit: 등록 DBMS_JOB.remove: 삭제 DBMS_JOB.change: 변경 DBMS_JOB.next_date: 다음 JOB 실행시간 DBMS_JOB.interval: 실행 Cycle DBMS_JOB.what: 프로시저 변경 DBMS_JOB.run: 수동 실행

VAR jobno NUMBER BEGIN   DBMS_JOB.SUBMIT(:jobno ,'PROC_BATCH;',SYSDATE,'SYSDATE+1/60/24'); END; / COMMIT; 1분마다 PROC_BATCH실행