job 執行時間為每小時3次，分別在10分，30分，50分
begin
SYS.DBMS_SCHEDULER.CREATE_JOB
(
job_name => 'SYS.BOBCAT_SOFT_VERSION_STATICS_J'
,start_date => TO_TIMESTAMP_TZ('2011/09/27 16:00:00.000000 +08:00','yyyy/mm/dd hh24:mi:ss.ff tzr')
,repeat_interval => 'FREQ=HOURLY;BYMINUTE=10,30,50'
,end_date => NULL
,job_class => 'DEFAULT_JOB_CLASS'
,job_type => 'STORED_PROCEDURE'
,job_action => 'DMP2WEB.BOBCAT_SOFT_VERSION_STATICS'
,enabled =>true
,comments => 'DMP2WEB.BOBCAT_SOFT_VERSION_STATICS'
);
end;
/
SYS.DBMS_SCHEDULER.CREATE_JOB
(
job_name => 'SYS.BOBCAT_SOFT_VERSION_STATICS_J'
,start_date => TO_TIMESTAMP_TZ('2011/09/27 16:00:00.000000 +08:00','yyyy/mm/dd hh24:mi:ss.ff tzr')
,repeat_interval => 'FREQ=HOURLY;BYMINUTE=10,30,50'
,end_date => NULL
,job_class => 'DEFAULT_JOB_CLASS'
,job_type => 'STORED_PROCEDURE'
,job_action => 'DMP2WEB.BOBCAT_SOFT_VERSION_STATICS'
,enabled =>true
,comments => 'DMP2WEB.BOBCAT_SOFT_VERSION_STATICS'
);
end;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23757700/viewspace-708389/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
干的活儿
请登录后发表评论
登录
全部评论
