Query to get ESS Job Status

 When we submit an ESS Job requested we can check the status from the backend,

Below is the SQL to get ESS Status 

SELECT state,
       requestid,
       NAME,
       executable_status,
       error_warning_message,
       error_warning_detail,
       cmdline,
       workdirectoryroot,
       logworkdirectory,
       inputworkdirectory,
       outputworkdirectory,
       redirectedoutputfile
FROM   fusion_ora_ess.request_history
WHERE  requestid = 20780---Please pass requst id

ORDER  BY requestid DESC