How To Get AS400/iSeries Job Queue Information Using SQL
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:
- How To Throttle The Job Queue
- How To Add An iSeries JobQueue To Oracle JDE EnterpriseOne
- Quick Tip: Hold All JDE Job Queues
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
More Stories
How to Print a Directory Structure Using PowerShell: Step-by-Step Guide
If you need to print out the directory structure and list the files within, this PowerShell script will help you...
Windows God Mode… What!?!
Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.
How To Test A SQL Server Connection
There is an easy way to test your SQL Server connection when running Windows without any special software. I found...
4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell
I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day....
Get The Size & Record Count Of All Tables In A SQL Server Database
Use the SQL query below to display the size and record count of all tables in an SQL Server database....
The EnterpriseOne CNC Job Description
The JD Edwards ERP Specialist is responsible for maintaining the JD Edwards EnterpriseOne platform and auxiliary systems from a development, CNC, system administration, and functional consultant perspective to create and maintain business solutions.
Average Rating