Oracle DBMS_SCHEDULER
Paket DBMS_SCHEDULER menyediakan koleksi fungsi dan prosedur penjadualan yang dapat dipanggil dari program PL/SQL.
#DBMS_SCHEDULER
BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB
(
job_name => ‘COMPILE_SCHEMA_SCOTT’
,start_date => SYSDATE
,repeat_interval => ‘FREQ=DAILY;BYHOUR=7;BYMINUTE=0;BYSECOND=0′
,end_date => NULL
,job_class => ‘DEFAULT_JOB_CLASS’
,job_type => ‘PLSQL_BLOCK’
,job_action => ‘begin
dbms_utility.compile_schema(”SCOTT”);
end;’
,comments => ‘Compile schema scott’
);
SYS.DBMS_SCHEDULER.ENABLE
(name => ‘COMPILE_SCHEMA_SCOTT’);
END;
/
Tags: Oracle
