Monthly Archives: January 2016

Query – PeopleSoft Jobs & processes that took more than 60 minutes to run

The following query can be used to identify any long running processes from the process request table.

It identifies any processes that took more than 60 minutes to run.

WITH GOT_RUN_MINUTES AS
(SELECT SERVERNAMERUN,
PRCSINSTANCE,
ORIGPRCSINSTANCE,
PRCSTYPE,
PRCSJOBNAME,
PRCSNAME,
RUNDTTM,
RQSTDTTM,
OPRID,
(SELECT XLATSHORTNAME
FROM PSXLATITEM
WHERE FIELDNAME = 'RUNSTATUS'
AND FIELDVALUE = RUNSTATUS
) AS RUNSTATUS,
BEGINDTTM,
ENDDTTM,
(TO_DATE (TO_CHAR (ENDDTTM, 'dd/mm/yyyy hh24:mi:ss'), 'dd/mm/yyyy hh24:mi:ss' )-TO_DATE (TO_CHAR (BEGINDTTM, 'dd/mm/yyyy hh24:mi:ss'), 'dd/mm/yyyy hh24:mi:ss' ))*(24*60) AS MINUTES
FROM PSPRCSRQST
WHERE RQSTDTTM > SYSDATE-1
ORDER BY RQSTDTTM DESC
)
SELECT SERVERNAMERUN,
PRCSINSTANCE,
ORIGPRCSINSTANCE,
PRCSTYPE,
PRCSJOBNAME,
PRCSNAME,
RUNDTTM,
RQSTDTTM,
OPRID,
RUNSTATUS,
BEGINDTTM,
ENDDTTM,
MINUTES
FROM GOT_RUN_MINUTES
WHERE MINUTES > '60';

Center align data in a PeopleSoft grid using JavaScript

I had a requirement to center align data in a PeopleSoft grid. Instead of messing with the delivered Style Sheets and creating new ones I simply adding an HTML area to my page and used JavaScript to center it.

getElementsByClassName() returns a HTMLCollection so you need to iterate through the results.

Here is the JavaScript example:


var elements = document.getElementsByClassName("PSLEVEL1GRIDODDROW");
for(var i=0, l=elements.length; i<l; i++)
{
elements[i].style.textAlign = "center";
}