How To Get AS400/iSeries Job Queue Information Using SQL

Read Time:52 Sec

I received a request the other day about the JD Edwards EnterpriseOne job queues and what the maximum number of concurrent jobs was for each. You may or may not be aware that when EnterpriseOne is running on an IBM AS400/iSeries, the maximum number of concurrent jobs is controlled by the Job Queue definition within the Operating System. Getting this information from the P986130/F986130 in JDE isn’t necessarily correct.

I addressed some of this in the following posts:

They use a series of IBM AS400/iSeries Commandline commands to get the information one Job Queue at a time. I needed something that I could easly export to Excel or plain text.

So, I found this little SQL statement that can be run:

SELECT JOBQ,JOBQ_LIB,STATUS,SUB_NAME,MAX_JOBS
   FROM QSYS2.JOB_QUEUE_INFO
    ORDER BY SUB_NAME

That should give you what you need.

Have fun!

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA  What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

E1Tips.com Previous post The EnterpriseOne CNC Job Description
Next post Get The Size & Record Count Of All Tables In A SQL Server Database