How to obtain details that will provide information about what process is scheduled?
In this blog post, will provide some sample technical queries which will provide details on the ESS process which are scheduled.
1. Find all the schedules
SELECT x.REQUESTID,x.NAME,x.DEFINITION,x.SCHEDULESTATE, x.LASTSCHEDULEINSTANCEID
FROM FUSION_ORA_ESS.REQUEST_HISTORY x where
x.parentrequestid = -1 and x.REQUESTTYPE=2 and x.state = 1
2. Find all the schedules for a specific ESS job.
SELECT x.REQUESTID,x.NAME,x.DEFINITION,x.SCHEDULESTATE, x.LASTSCHEDULEINSTANCEID
FROM FUSION_ORA_ESS.REQUEST_HISTORY x where
x.definition = '<Job Definition>'
and x.parentrequestid = -1 and x.REQUESTTYPE=2
