E1Tips.com - SQL Ninja

Quick Tip: Hold All JDE Job Queues

Read Time:21 Sec

The following SQL statement will put all JDE Job Queues on hold:

UPDATE
SY920.F986130
SET QCQUSTS='02'

This statement is very helpful when dealing with a system that has many job queues because the P986130 (Job Queue Maintenance) only allows you to place a single job queue on hold at a time.

Hope this helps someone else, but if not at least it’s permanently in my bag of tricks. 🙂

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%

4 thoughts on “Quick Tip: Hold All JDE Job Queues

    1. Hi, Tom. The advantage is that you don’t have to click through each job queue to put it on hold. That can be very tedious work if you have a lot of job queues.

      If you are only worried about the Scheduler jobs and you are ok with some scheduled jobs getting missed, I would say stopping the scheduler would be your best option. However, if you are worried about a user sneaking in a UBE during a maintenance period or you don’t want to skip any scheduled jobs, I would put the job queues on hold.

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.

Previous post Quick Tip: IBM i (iSeries / AS400) Spool File Navigation
Next post Quick Tip: How To Delete Multiple SQLPKGs