ORACLE schedule job设置

--创建job
begin 
    DBMS_SCHEDULER.CREATE_JOB ( 
    job_name => ‘APICALL_LOG_INTERFACE_JOB‘, 
    job_type => ‘STORED_PROCEDURE‘, 
    job_action => ‘APICALL_LOG_INTERFACE_CLEAN‘, 
    start_date         =>  to_date(‘2016/4/23 1:00:00‘,‘YYYY/MM/DD hh24:mi:ss‘),
    Repeat_Interval    =>  ‘FREQ=DAILY; INTERVAL=1‘,
    Enabled => True, 
    Comments => ‘APICALL_LOG_INTERFACE 清理五天前的数据‘ 
    ); 
End; 

SELECT * FROM DBA_SCHEDULER_JOBS; -- 查询job

begin
DBMS_SCHEDULER.DROP_JOB(JOB_NAME => ‘APICALL_LOG_INTERFACE_JOB‘); --删除job
end;

ORACLE schedule job设置

标签：