How to Find All Scheduled ESS Jobs, Frequency, Submitted By, And Other Inofmration?
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 :
Both returned weird characters or xml format column.
Code Snippet :
SELECT REQUESTID, NAME, DEFINITION, REQUESTTYPE, STATE, SUBMISSION, adhocschedule