Oracle新建定时任务Job

---

 

begin
  sys.dbms_scheduler.create_job(job_name            => 'APP_DDCS.JOB_SYNC_DDRC_RES_FAIL',
                                job_type            => 'PLSQL_BLOCK',
                                job_action          => 'DECLARE PO_FLAG NUMBER;PO_MSG VARCHAR2(500);
    BEGIN
      PKG_DD_RESPONS_COMM.PROC_SYNC_DDRC_RES_FAIL(PO_FLAG,PO_MSG);
    END;',
                                start_date          => to_date('24-01-2014 15:18:53', 'dd-mm-yyyy hh24:mi:ss'),
                                repeat_interval     => 'Freq=DAILY;ByHour=22;ByMinute=59;BySecond=08',
                                end_date            => to_date(null),
                                job_class           => 'DEFAULT_JOB_CLASS',
                                enabled             => true,
                                auto_drop           => false,
                                comments            => 'SYNC DDCCS to CSDD_FAILED');
end;
/