Re: "Missing" Jobs

True that Dawn. But if he wants to expand from the summary it's a simple
matter of dropping the GROUP BY and adding any desired WHEREs

On Thu, Dec 28, 2023 at 9:33 AM Dawn May <dawnmayican@xxxxxxxxxxx> wrote:

I like using DSPJOBTBL, then F11 to identify where all the jobs are.

It will show the counts of active jobs, jobs on job queues, jobs on output
queues and jobs that are job log pending.

If you prefer SQL, QSYS2.System_Status_Info also has this information.

Dawn
Email: dawnmayican@xxxxxxxxxxx
Web: Dawnmayi.com
Twitter: DawnMayiCan
Blog: https://techchannel.com/SMB/i-can-blog
LinkedIn: https://www.linkedin.com/in/dawnmay/

On Dec 27, 2023, at 11:22 AM, Rob Berendt <robertowenberendt@xxxxxxxxx>

wrote:

*-- DSPSYSSTS: Jobs in system . . . . . : 72967*

select X.JOB_STATUS, X.JOB_TYPE, *count*(*)
from TABLE(QSYS2.JOB_INFO(
JOB_USER_FILTER *=>* '*ALL'
)) X
group by x.job_status, x.job_type
order by x.job_status, x.job_type
;
JOB_STATUS JOB_TYPE 00003
ACTIVE ASJ 8
ACTIVE BCH 220
ACTIVE BCI 46
ACTIVE INT 273
ACTIVE PDJ 6
ACTIVE PJ 136
ACTIVE SYS 56
ACTIVE WTR 141
OUTQ BCH 40688
OUTQ BCI 16732
OUTQ INT 14622
OUTQ PDJ 2
OUTQ PJ 21
OUTQ WTR 1

On Wed, Dec 27, 2023 at 10:53 AM Rich Loeber <rich@xxxxxxxxx> wrote:

I think I've asked this before but I'm still puzzled by what might be
going on. The system that we use for development is a small partition

on a

larger machine. I did a full IPL this morning and then cleaned up all

the

junk that showed up in the job log output queue. I also ran the

WRKJOBLOG

command and cleared all those as well. When I run the WRKSYSSTS

command,

it reports that there are 890 jobs in the system. If I count the jobs
shown on WRKACTJOB, I see 207 active. If I count the number of spool

files

using WRKOUTQ for all queues on the system, I see another 106 jobs

active.

That adds up wot 313 jobs.

So, where are the other "missing" 577 jobs?

Rich Loeber
Kisco Systems LLC
https://www.kisco.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related

questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.