Saturday, July 7, 2012

Find Job Queues of all UBEs running



SELECT T1.JCPID, T0.JCJOBQUE, COUNT(*)
  FROM SVM812.F986110 T0, SVM812.F986114 T1
 WHERE T0.JCJOBNBR = T1.JCJOBNBR
   AND T0.JCEXEHOST = 'ryelxjdlabtp'
--AND T0.JCFNDFUF2 LIKE 'R31802A%'
 GROUP BY T1.JCPID, T0.JCJOBQUE
 ORDER BY T1.JCPID, T0.JCJOBQUE;

No comments:

Post a Comment