How to find current status of PeopleSoft process scheduler
Process Scheduler plays an important role in PeopleSoft application by performing batch transactions & running processes and reports. Due to its significance in PeopleSoft architecture, availability of process scheduler become critical.
Most of the organizations deploy multiple process scheduler to handle the requests. Still at times, process scheduler can behave erratically (specially when running on Windows). This can result in lot of processes being queued and not getting executed.
To check the availability of Process scheduler, you can deploy monitoring scripts which can notify you in case of any issues. If needed, you can also check the status of process manually. There are several ways to find out the current status of process scheduler.
Find process scheduler status from process monitor
Go to PeopleTools > Process Scheduler > Process Monitor and navigate to ‘Server List’ tab.
On this page, you will see the process scheduler with current status for the PeopleSoft database.
Another way to find the current status of process scheduler is via below SQL.
–Find if Process Scheduler is up and running
SELECT A.SERVERNAME, B.XLATSHORTNAME,A.SRVRHOSTNAME
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;
This SQL will show the servername, current status and hostname on which it’s running. Process monitor also shows the status based on values in table (PSSERVERSTAT)
Sometimes, process scheduler gets stuck and current status isn’t shown in process monitor or tables. In that case you must check the server status using psadmin utility on Process Scheduler server.