Answer the question
In order to leave comments, you need to log in
How to convert cp1251 to utf8 in zabbix?
Hello!
I monitor Oracle through zabbix.
SELECT Nvl(Listagg(Reg_Date || Chr(13) || Er, Chr(13) || Chr(13) || Chr(13)) Within GROUP(ORDER BY Reg_Date DESC), '1') "Emp_list"
FROM (
SELECT MAX(j.Req_Start_Date) AS Reg_Date,
j.Additional_Info AS Er
FROM dba_Scheduler_Job_Run_Details j
WHERE j.Owner || '.' || j.Job_Name = '{#JBN}'
AND j.Status = 'FAILED'
AND j.Req_Start_Date >= SYSDATE - 1 / 24
GROUP BY j.Additional_Info)
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question