[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.set_attribute(name=>'SJ_WM_DD_IO_GEN', attribute => 'job_action', value =>'BEGIN TLSP_PRD.SP_WM_DD_IO_GEN(SYSDATE); END;');

 

 

3. disable 시키기

exec dbms_scheduler.disable('test_user.test1');