ESS - Duplicate ESS Jobs in Running Mode
Published September 21, 2025
By Sai Sree Ram Gundepudi
SELECT COUNT(DEFINITION) AS COUNT, DEFINITION
FROM FUSION_ORA_ESS.request_HISTORY
WHERE STATE = 3
GROUP BY DEFINITION
HAVING COUNT(DEFINITION) > 20
ORDER BY 1 DESC;