我怎样调用job刷新多个快照？

Question

@路径+文件.sql;
看看行不行~~

Answer 1

你试下
VARIABLE jobno number;
begin
      DBMS_JOB.SUBMIT(:jobno,
              'declare
                begin
                  EXECUTE DBMS_SNAPSHOT.REFRESH('snapshot1');
                  EXECUTE DBMS_SNAPSHOT.REFRESH('snapshot2');
                  EXECUTE DBMS_SNAPSHOT.REFRESH('snapshot3');
                end;',
               SYSDATE, 'SYSDATE + 1/720');
         commit;
end;
/