ORACLE schedule job設定

標籤：

--建立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 清理五天前的資料‘     ); End; SELECT * FROM DBA_SCHEDULER_JOBS; -- 查詢jobbeginDBMS_SCHEDULER.DROP_JOB(JOB_NAME => ‘APICALL_LOG_INTERFACE_JOB‘); --刪除jobend;

　　

ORACLE schedule job設定