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 

 --- SQL Query to find Execution Time in Minute 

 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

 --Create Table based on above Select Query 

 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

 -- 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