Wednesday, February 27, 2019

How Long Are My PeopleSoft Processes Running? An SQL Answer.

In testing our Campus Solutions 9.2 upgrade environment, we wanted to find out if the processes are running any longer in the upgrade environment than they normally do in production.  We came up with the following query to help us do that.




The SQL looks like this:
SELECT    TO_CHAR(enddttm,'DAY') day,    enddttm - begindttm,    enddttm,    begindttmFROM    sysadm.psprcsrqstWHERE    prcsname = 'SCC_SI_ASSN'    AND   runcntlid = 'SCC_SI_ASSN_FR1'    order by 2 desc;
The query orders the results by longest run times to shortest (column 2).  Notice also in the example below that the process seems to run significantly longer on Mondays (22 minutes 50 seconds down to 18 minutes 1 second) than on other days.


Here's a different example where the process seems to run about the same amount of time regardless of which day of the week it is:


No comments: