Oracle计划任务

计划任务

 begin  
       dbms_scheduler.create_job (
        job_name            => 'DELETE_Tbl_Log',
        job_type            => 'PLSQL_BLOCK',
        job_action          => 'delete tbl_sys_log where logdate<(to_timestamp( sysdate)-7 );
        commit;',
        start_date          => to_date('01-02-2016 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
        repeat_interval     => 'Freq=Daily;Interval=1;ByHour=00;ByMinute=00;BySecond=00',
        end_date            => to_date(null),
        job_class           => 'DEFAULT_JOB_CLASS',</