job

BEGIN
  DBMS_SCHEDULER.CREATE_JOB(JOB_NAME        => 'JOB_ScorTemplateGeneral',
                            JOB_TYPE        => 'PLSQL_BLOCK',
                            JOB_ACTION      => 'DECLARE BEGIN PKG_SCORE.ScorTemplateGeneral END;',
                            START_DATE      => SYSDATE,
                            REPEAT_INTERVAL => 'FREQ=DAILY;INTERVAL=1;BYHOUR=0;BYMINUTE=0;BYSECOND=0',
                            COMMENTS        => '表单生成JOB');
                            --Hourly   间隔每小时
                            --DAILY     间隔每天
                            --Minutely   间隔每分钟
                            --上面是间隔一天
END;
/
begin
  sys.dbms_scheduler.enable(name => 'DPSRMTEST.JOB_ScorTemplateGeneral');
end;
/