ESS - Jobs That May Block Other Jobs From Running
Published September 21, 2025
By Sai Sree Ram Gundepudi
SELECT REQUESTID, DEFINITION
FROM FUSION.ESS_REQUEST_HISTORY
WHERE state IN (3,6,7,13,19)
AND DEFINITION IN (
SELECT DEFINITION
FROM FUSION.ESS_REQUEST_HISTORY
WHERE state = 5
);