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;
/
job
最新推荐文章于 2023-08-27 21:19:35 发布