Hi Team - I've executed below query to pull the list of UC4 failed jobs for SYSDATE-1.
But One of the workflow "WORKFLOW.INFA.HUB_MART.FINANCE_PA_INCREMENTAL_NOTIFY" is failed. But its not tracked in our failed query result.
Pls below the below query & result set.
select
DECODE(ah_QUEUE,
'QUEUE.BODI','BODI',
'QUEUE.TIBCO','TIBCO',
'QUEUE.INFA.EDM.HUB','INFA.EDM.HUB',
'QUEUE.ADF','ADF',
'QUEUE.INFORMATICA','INFORMATICA',
'QUEUE.INFA.EDM.MART','INFA.EDM.MART',
'CLIENT_QUEUE','CLIENT_QUEUE')AS JOB_QUEUE,
ah_name as JOB_NAME,
ah_idnr as RUN_ID,
ah_timestamp1 as ACTIVATON_TIME,
ah_timestamp2 as "START_TIME",
--ah_timestamp3 as post_proc,
ah_timestamp4 as END_TIME,
DECODE(ah_status,
1900,'ENDED_OK - ended normally',
1560,'Workflow is blocked',
1850,'ENDED_CANCEL - manually canceled',
1851,'ENDED_JP_CANCEL - Workflow canceled manually',
1800,'ENDED_NOT_OK - aborted',
1820,'FAULT_OTHER - Start impossbile. Other error',
1930,'ENDED_SKIPPED - Skipped because of WHEN clause',
1920,'ENDED_INACTIVE - Inactive today because of Calendar') AS JOB_STATUS
from uc4p.ah
where ah_otype in ('JOBP','JOBS')
and ah_status not between 1900 and 1999
and ah_timestamp2 > sysdate-1
and ah_client=3000
and ah_timestamp4 is not null
order by 1 ASC,5 DESC;