Oracle 调度程序

创建一个定时调度作业

自动生成调度作业的代码

作业

编辑作业

程序

编辑程序

调度

编辑调度

create or replace 
package body WWOHIN is
  --Daily refresh (01:00)
  procedure DAILY_REFRESH_0 is
     ALL_START_DT DATE;
    START_DT     DATE;
    JOB_NAME     varchar2(100);
    RUNNING_DATE varchar2(30);
    SEQ_NUM      number(15);
  begin
    ALL_START_DT := sysdate;
    JOB_NAME     := 'DAILY_REFRESH_0';
    RUNNING_DATE := to_char(sysdate, 'yyyy-MM-dd');
    SEQ_NUM      := (sysdate - to_date('1970-1-1', 'yyyy-mm-dd')) * 86400 -
                    TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezone), 1, 3)) * 3600;
                    
    START_DT := sysdate;
    WMAL.MALAYSIA_KPI_DATE_UPDATE_DAILY;
    W_JOB_FILE_LOG_P(job       => JOB_NAME,
                     step      => 'WMAL.MALAYSIA_KPI_DATE_UPDATE_DAILY',
                     start_dt  => START_DT,
                     finish_dt => sysdate,
                     RUNNING_D => RUNNING_DATE,
                     SEQ_NUM   => SEQ_NUM);

     -- 写入整个Job时间
    W_JOB_FILE_LOG_P(job       => JOB_NAME,
                     step      => 'ALL',
                     start_dt  => ALL_START_DT,
                     finish_dt => sysdate,
                     RUNNING_D => RUNNING_DATE,
                     SEQ_NUM   => SEQ_NUM);                     
  end;