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. 🙂
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
What is the advantage of this solution? What’s the better way – hold job queues or switch off scheduler server?
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.
All right, thank you! Does it affect any running jobs?
No problem, Tom! This will not affect currently running jobs.