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 
 ); 
 

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article