HI All,
We have a requirement to create custom report to fetch scheduled job details like
ESS Job Name, ESS Job Creation date, ESS Job Created by, ESS Job Scheduled Frequency, ESS Start time, ESS End time, ESS Job Status, ESS Job Submitted by
Please help me to find above details.
We have below tables to identify few fields. But not sure how we have to get frequency of scheduled job. Ex: every hour?, every week?, every Wednesday at 5am?
select * from FUSION_ORA.ESS_REQUEST_HISTORY
select * from FUSION_ORA.ESS_REQUEST_PROPERTY
Regards,
Sushma