Program error

[RU]

Источник ошибки: Ядро мониторинга работы СУБД Oracle

Текст сообщения: Monitoring (Oracle job failed)

Информация

• Получение данных о заданиях за текущие сутки завершившие работу с ошибкой

Запрос

select job_name||' ('|| max(log_date)||')' "name", 
       count(*) "count" 
  from DBA_SCHEDULER_JOB_LOG 
 where log_date > sysdate - 1 
   and status ='FAILED' 
group by  job_name

Решение

Предоставить пользователю права на чтение данных системного каталога, например

grant select any dictionary to <UserName>;  
или
grant select on DBA_SCHEDULER_JOB_LOG to <UserName>;

[EN]

Error Source: Oracle DBMS Operation Monitoring Kernel

Message text: Monitoring (Oracle job failed)

Information

• Getting data about job for the current day that completed work with an error

Query

select job_name||' ('|| max(log_date)||')' "name", 
       count(*) "count" 
  from DBA_SCHEDULER_JOB_LOG 
 where log_date > sysdate - 1 
   and status ='FAILED' 
group by  job_name

Solution

Grant the user rights to read system directory data, for example

grant select any dictionary to <UserName>;  
or
grant select on DBA_SCHEDULER_JOB_LOG to <UserName>;