JD Edwards EnterpriseOne
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment