Wednesday, May 20, 2015

To Get a List of nVision Reports Run on the Scheduler with Layout Name, Last Run Time, Run Status etc.

You can find the information from Process Scheduler tables like PSPRCSQUE, PSPRCSPARMS, there is no specific table that stores such information just for nVision processes. In the PARMLIST field you can find the Layout name.

SELECT A.PRCSINSTANCE, A.JOBINSTANCE, A.PRCSJOBNAME, A.PRCSTYPE, A.PRCSNAME, TO_CHAR(CAST((A.RUNDTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), A.OPRID, A.RUNSTATUS, C.PARMLIST 
  FROM PSPRCSQUE A, PSPRCSPARMS C 
  WHERE ( A.PRCSTYPE LIKE 'nVision%' 
  AND A.PRCSINSTANCE = C.PRCSINSTANCE )
 

No comments :

Post a Comment