Cenário: oracle EE 11.2.0.4 Senhores, boa tarde. Existe um Scheduler Job Chains que foi criado e nao esta rodando. Nao consegui identificar o motivo do JOB não rodar no agendamento indicado, segue:
caso esteja dificil a visualizacao, upei o troubleshooting nesse txt: Untitled - Text Share Hosting online free | | | | Untitled - Text Share Hosting online free | | | ** DBA_SCHEDULER_JOBS OWNER JOB_NAME JOB_TYPE START_DATE REPEAT_INTERVAL END_DATE ENABL AUTO_ STATE MR FC MF RC Last_Started---------- ----------------- ------------ ------------------- ---------------------- ------------------- ----- ----- ---------- ----- ----- ----- ----- -------------------SYS GATHER_STATS CHAIN 11-04-2018 15:30 FREQ=DAILY; BYHOUR=21 TRUE TRUE SCHEDULED 0 0 ** dba_scheduler_chains OWNER CHAIN_NAME RULE_SET_O RULE_SET_NAME NUMBER_OF_RULES NUMBER_OF_STEPS ENABL ---------- ----------------------- ---------- --------------- --------------- --------------- ----- SYS JOB_CHAIN_GATHER_STATS SYS SCHED_RULESET$1 3 2 TRUE ** dba_scheduler_chain_steps OWNER CHAIN_NAME STEP_NAME PROGRAM_OW PROGRAM_NAME STEP_TYPE---------- ------------------------- --------------- ---------- --------------- -------------- SYS JOB_CHAIN_GATHER_STATS ETAPA_1 SYS GET_STATS_EMPTY PROGRAMSYS JOB_CHAIN_GATHER_STATS ETAPA_2 SYS GET_STATS_STALE PROGRAM ** dba_scheduler_chain_rules OWNER CHAIN_NAME RULE_OWNER RULE_NAME CONDITION ACTION ---------- ------------------------ ---------- --------------- ------------------------- -------------------- SYS JOB_CHAIN_GATHER_STATS SYS REGRA_1 TRUE START "ETAPA_1" SYS JOB_CHAIN_GATHER_STATS SYS REGRA_2 Etapa_1 COMPLETED START "ETAPA_2" SYS JOB_CHAIN_GATHER_STATS SYS REGRA_3_FINAL Etapa_1 COMPLETED and Etapa_2 COMPLETED END **DBA_SCHEDULER_JOB_RUN_DETAILS no rows selected