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