Histórico da Página

BEGIN
  SYS.DBMS_SCHEDULER.CREATE_JOB(JOB_NAME            => 'CONSINCO.EXCLUSAO_BC_PISCOFINS',
                                JOB_TYPE            => 'PLSQL_BLOCK',
                                JOB_ACTION          => '-- EXCLUSÃO BASE CALC PIS/COFINS --
BEGIN
  FOR T IN (
            SELECT X.NROEMPRESA
              FROM GE_EMPRESA X
             WHERE X.STATUS = ''A''
             ORDER BY X.NROEMPRESA
  )
  LOOP
    PKG_FIS00361.RFP_INICIAGERACAO(pnNroEmpresa => T.NROEMPRESA, pdDtaAgendamento => SYSDATE);
  END LOOP;
END;',
                                START_DATE          => SYSDATE,
                                REPEAT_INTERVAL     => 'Freq=Minutely;Interval=5',
                                END_DATE            => TO_DATE(NULL),
                                JOB_CLASS           => 'DEFAULT_JOB_CLASS',
                                ENABLED             => TRUE,
                                AUTO_DROP           => FALSE,
                                COMMENTS            => 'Exclusão Base Calc PIS/COFINS');
END;