Oracle[문법] Job(찾기)_스케줄러 조회,등록,삭제,실행 변경

ORACLE[문법] JOB_스케줄러 조회,등록,삭제,실행,변경 등

* job조회

SELECT *

FROM USER_JOBS;

* dba_jobs 테이블에서 확인

SELECT *

FROM DBA_JOBS

 

* job등록

EXECUTE dbms_job.submit( JOBNO, 'USER_NAME.PROCEDURE_NAME;', TRUNC(SYSDATE)+23/24, 'TRUNC(SYSDATE+1)+23/24', FALSE);

commit;

 

* job(잡) stop

EXECUTE dbms_job.broken(JOB_No, FALSE);

commit;

* job(잡) del

EXECUTE dbms_job.REMOVE(JOB_No);

* job(잡) edit

EXECUTE DBMS_JOB.NEXT_DATE(4, TRUNC(SYSDATE)+1+1/24/60);

* job(잡) run

EXECUTE DBMS_JOB.RUN(JOB_No);

commit;