Query to find details of Scheduled Processes ESS jobs?
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,