--創(chuàng)建jobbegin 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 清理五天前的數(shù)據(jù)' );End;SELECT * FROM DBA_SCHEDULER_JOBS; -- 查詢jobbeginDBMS_SCHEDULER.DROP_JOB(JOB_NAME => 'APICALL_LOG_INTERFACE_JOB'); --刪除jobend; |
|
|
