Query to find details of Scheduled Processes ESS jobs?

Dec 27, 2024 10:33AM

Summary:

Hi Team,

we have requirement to fetch all ESS jobs from Scheduled Processes UI.

while i am checking the backend tables unable to fetch the name of scheduled process

Tables: REQUEST_HISTORY, ess_request_history

Ex: i have Send Pending LDAP Process unable to find the details in backend

Thanks,

Vishnu

Query:

SELECT
requestid,
DECODE ( state,1, 'Scheduled',10, 'ERROR',11, 'WARNING',12, 'SUCCEEDED',6, 'Hold',state) STATE,
SUBSTR (definition, (INSTR (definition, '/', - 1) + 1)) Name ,
TO_TIMESTAMP(SUBSTR((SUBSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule),chr(0),''),INSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule),chr(0),''),'<start>') +LENGTH('<start>'),INSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule),chr(0),''),'</start>') - INSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule),chr(0),''),'<start>') -LENGTH('<start>'))),1,19), 'YYYY-MM-DD HH24:MI:SS') SCHEDULE_START,

Query to find details of Scheduled Processes ESS jobs?

Howdy, Stranger!