Program

▣ 실행될 프로그램 등록

▶ Show SQL

BEGIN

DBMS_SCHEDULER.CREATE_PROGRAM(

program_name=>'SYS.myProgram',

program_action=>'begin

     insert into hr.x.values(hr.xs.nextval,''myJob done by myPrg'',systimestamp);

end;',

program_type=>'PLSQL_BLOCK',

number_of_arguments=>0,

comments=>'',

enabled=>TRUE);

END;

   

▣ 등록한 Program을 Job에 등록

   

▶ Show SQL

BEGIN

sys.dbms_scheduler.set_attribute_null( name => '"SYS"."MYJOB"', attribute => 'job_type');

sys.dbms_scheduler.set_attribute_null( name => '"SYS"."MYJOB"', attribute => 'job_action');

sys.dbms_scheduler.set_attribute_null( name => '"SYS"."MYJOB"', attribute => 'number_of_arguments');

sys.dbms_scheduler.set_attribute( name => '"SYS"."MYJOB"', attribute => 'program_name', value => 'SYS.MYPROGRAM');

END;

   

▣ 실행확인