scheduler
-
ORACLE - Scheduler JOBDB/Oracle 2025. 1. 6. 17:57
매일, 17시와 19시에 10분 15분 마다 돌리는 스케쥴 잡 생성 예시BEGIN SYS.DBMS_SCHEDULER.DROP_JOB (job_name => '스키마.PR_PROC_JOB_NAME');END;/BEGIN SYS.DBMS_SCHEDULER.CREATE_JOB ( job_name => '스키마.PR_PROC_JOB_NAME' ,start_date => TO_TIMESTAMP_TZ('2025/01/02 01:30:02.000000 +09:00','yyyy/mm/dd hh24:mi:ss.ff tzh:tzm') ,repeat_interval => 'FREQ=DAILY; BYHOUR=17,19; BYMINUTE=10,15' ,..