ESS - Check Ready Jobs

Published September 21, 2025 By Sai Sree Ram Gundepudi
SELECT  
     REQUESTID, SYSDATE, SUBMISSION, REQUESTEDSTART, READYTIME, PROCESSSTART 
 FROM FUSION_ORA_ESS.request_history 
 WHERE state = 2 
   AND READYTIME < (SELECT SYSDATE - INTERVAL '1' MINUTE FROM dual); 
 

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article