Free Fusion SQLScheduler (ESS)Read-only

ESS scheduled jobs in last 24h

All ESS requests submitted in the last 24 hours with status — operations dashboard view.

Get the free ITGC & reporting query pack by email All 20 free queries

Tables used

ess_request_history

Bind parameters

None — the statement runs as written; edit the literals in the WHERE clause to narrow it.

How to run it

Paste it into a BI Publisher data model as a SQL data set, or into QueryWell's Query Studio and run it against your pod with a reporting account. Results come back to a grid you can profile, chart and export with a SHA-256 hash.

SQLdba-ess-recent-jobs

SELECT r.requestid, r.application, r.definition, r.submitter, r.state,
  r.processstart, r.processend, r.completedtime, r.elapsedtime
FROM ess_request_history r
WHERE r.processstart >= SYSTIMESTAMP - INTERVAL '1' DAY
ORDER BY r.processstart DESC

A single read-only SELECT against Oracle Fusion Cloud's supported reporting surface. Column names and views can differ by release and by the roles your reporting account holds, so validate the result against a report you already trust before relying on it.

essscheduleroperations

Long-running ESS jobs (>30 min)

ESS requests whose runtime exceeded 30 minutes in the last 7 days — performance hotspots.

Run it without the template cycle

QueryWell runs this and 81 other curated scripts against your own Fusion pod from one signed desktop app — grid, charts, profiling and hashed exports included. Perpetual licence, 14-day trial.

Start a free 14-day trial Get the free query pack by email