--创建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;