How to Find All Scheduled ESS Jobs, Frequency, Submitted By, And Other Inofmration?
Summary:
Just like the title says, we are having trouble find that information. I wrote the SQL Below which does return the required information but in XML/BLOB Format. Which im having trouble decoding.
I tried the following :
TO_CHAR(SUBSTR(UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(adhocschedule)) ,4,4000))
TO_CHAR(adhocschedule, 1000)
Both returned weird characters or xml format column.
Code Snippet :
SELECT REQUESTID, NAME, DEFINITION, REQUESTTYPE, STATE, SUBMISSION, adhocschedule
from fusion_ora_ess.request_history
Tagged:
0