[ORACLE] Schduer job 명령어

1. scheduler job 생성 BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name=>'SCHEULSER_JOB_TEST1', job_type=>'PLSQL_BLOCK', job_action=>'BEGIN PROC_test1T(); END;', start_date=>TRUNC(SYSDATE+1)+07/24, repeat_interval=>'FREQ = DAILY; BYHOUR = 07,13', end_date=>NULL, job_class=> 'DEFAULT_JOB_CLASS', enabled=> TRUE, auto_drop=> TRUE, comments=> 'TEST Sechduler job'); END; 2. attribute 수정 execute dbms_scheduler..