Query to get ESS Job Last Run Date

 SELECT NVL(Max(erh.processstart), NULL) last_run_date

        FROM   ess_request_history erh,

               ess_request_property erp1

        WHERE  erh.executable_status = 'SUCCEEDED'

               AND erp1.requestid = erh.requestid

              --AND erp1.name = 'submit.argument1'

               AND erh.DEFINITION =

       'JobDefinition://oracle/apps/ess/custom/scm/sourcing/XXPurchaseAgreementNumbers_Sirion'