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