How to monitor PeopleSoft process scheduler for availability?
There are many approaches to monitor the PeopleSoft process scheduler. One of the options that come to mind is to have a script running on the OS hosting the process scheduler to monitor the OS process. But having process schedulers running on multiple OS (PSUNX and PSNT) will need development of scripts running on both servers.
My preferred method is to use the below SQL to monitor all the process schedulers running on the database.
SELECT A.SERVERNAME, B.XLATSHORTNAME,B.FIELDNAME,B.FIELDVALUE,TO_CHAR(B.EFFDT,’YYYY-MM-DD’)
FROM PSSERVERSTAT A, PSXLATITEM B
WHERE B.EFFDT =
(SELECT MAX(B_ED.EFFDT) FROM PSXLATITEM B_ED
WHERE B.FIELDNAME = B_ED.FIELDNAME
AND B.FIELDVALUE = B_ED.FIELDVALUE
AND B_ED.EFFDT <= SYSDATE)
AND B.FIELDNAME = ‘SERVERSTATUS’
AND B.FIELDVALUE = A.SERVERSTATUS
Depending on the results of the above SQL you can trigger an email notification or any other form of action.