JDE Submitted Job Execution Performance

Jobs in JDE Need to be evaluate for performance. Below Query will give Minimum, Average and Maximum Runtime of Jobs 

 --Create Table based on above Select Query 

 SELECT JCJOBNBR,JCPID,JCVERS,JCSTDTIM,JCETDTIM,DATEDIFF(MINUTE,JCSTDTIM,JCETDTIM) AS EXECUTION_MINUTE INTO SVM920.F986114_EXECUTION FROM SVM920.F986114 WHERE JCENHV LIKE '%PD920%' AND JCJOBSTS='D' AND DATEDIFF(MINUTE,JCSTDTIM,JCETDTIM) >0 ORDER BY JCPID,JCVERS,EXECUTION_MINUTE DESC

 --- SQL Query to find Execution Time in Minute 

SQL SERVER - 

 SELECT JCJOBNBR,JCPID,JCVERS,JCSTDTIM,JCETDTIM,DATEDIFF(MINUTE,JCSTDTIM,JCETDTIM) AS EXECUTION_MINUTE FROM SVM920.F986114 WHERE JCENHV LIKE '%PD920%' AND JCJOBSTS='D' AND DATEDIFF(MINUTE,JCSTDTIM,JCETDTIM) >0 ORDER BY JCPID,JCVERS,EXECUTION_MINUTE DESC

AS400 -> 

SELECT JCJOBNBR,JCPID,JCVERS,JCSTDTIM,JCETDTIM,TIMESTAMPDIFF(4, char(JCETDTIM - JCSTDTIM)) AS EXECUTION_MINUTE FROM SVM920.F986114 WHERE 

JCPID='R55TRE03' AND JCVERS='SSI00001' 

AND JCENHV LIKE '%PD920%' AND JCJOBSTS='D'   AND TIMESTAMPDIFF(4, char(JCETDTIM - JCSTDTIM)) >0

ORDER BY JCJOBNBR DESC,JCVERS,EXECUTION_MINUTE DESC;

 -- Finally Find Minimum, Average and Maximum Time for Job to complete 

 SELECT JCJOBNBR, JCPID, JCVERS, MIN(EXECUTION_MINUTE) AS MINIMUM,AVG(EXECUTION_MINUTE) AS AVERAGE,MAX(EXECUTION_MINUTE) AS MAXIMUM FROM SVM920.F986114_EXECUTION GROUP BY JCPID,JCVERS