原创: DBMS_SCHEDULER 中度解析: part 1

laou2008

收藏

yuxuan

知识在于积累

jolly10

这个要顶

qiudan5221

缺个window

kongxianxuan

期待下一部分

peitomb

为什么JOB执行完毕后
在dba_scheduler_running_jobs中不消失？

begin
   dbms_scheduler.create_schedule(
     schedule_name => 'RM_DAILY_SCHEDULE',
     start_date => systimestamp at time zone 'PRC',
     repeat_interval=> 'FREQ=DAILY;BYHOUR=21;BYMINUTE=45;BYSECOND=0',
     comments=>'RM JOB SCHEDULE WITH CHAIN DAILY');
end;
/

-- 3.创建program, 注意不要使用exec，会出错
begin
dbms_scheduler.create_program(
     program_name=> 'FLASH_REPORT_MVIEW',
     program_type=> 'PLSQL_BLOCK',
     program_action=> 'begin
                         dbms_mview.refresh(''VM_DEVICE'', method => ''complete'');
                       end;');
end;
/


-- 4.创建chain
BEGIN
  dbms_scheduler.create_chain(chain_name =>'RM_CHAIN_DAILY',
    rule_set_name => NULL,
    evaluation_interval => NULL);

  dbms_scheduler.enable('RM_CHAIN_DAILY');
END;
/

-- 5.定义步骤
BEGIN
  dbms_scheduler.define_chain_step(
    chain_name =>'RM_CHAIN_DAILY',
    step_name =>'STEP1_FLASH_REPORT_MVIEW',
    program_name =>'FLASH_REPORT_MVIEW');

  dbms_scheduler.alter_chain(
    chain_name =>'RM_CHAIN_DAILY',
    step_name =>'STEP1_FLASH_REPORT_MVIEW',
    attribute=>'skip',
    value=>FALSE);
END;
/


-- 创建JOB
BEGIN
dbms_scheduler.create_job(
  job_name => 'RM_JOB',
  job_type => 'CHAIN',
  job_action => 'RM_CHAIN_DAILY',
  schedule_name => 'RM_DAILY_SCHEDULE',
  job_class => 'DEFAULT_JOB_CLASS',
  auto_drop => FALSE,
  enabled => TRUE);
END;
/

刷新这张物化视图只需要几秒钟的时间，等了一分多钟，JOB还是不结束?
咋回事？视图刷好像刷了

88632578

part3呢？

Falange

good