Re: Is there an easy way, in CL, to find out if there are other jobs with a known jobname active or scheduled?

On 7/15/26 10:57 AM, Daniel Gross wrote:
> A small SQLRPGLE program (maybe wrapped into a CMD) might be your best bet.
> 
> With the JOB_INFO table function you receive exactly what you need.
> 
> - https://www.ibm.com/docs/en/i/7.6.0?topic=services-job-info-table-function
> 
> With a receiver variable you can return the job count.

Hmm.

First, I've literally never used SQLRPGLE. But that's not exactly 
intsurmountable.

Second, on our V7R5 cloud box,

> select * from TABLE(QSYS2.JOB_INFO(JOB_NAME_FILTER => 'WTCPSERVER'))

just comes back with an error message

> Named argument JOB_NAME_FILTER for routine JOB_INFO not valid for reason code 1.

in spite of the fact that the V7R5 docs for that function say the 
argument does exist.

Third, on the V7R3 customer box where I need this, in spite of the fact 
that the V7R3 docs say the function exists (even though the argument 
doesn't), I get

> JOB_INFO in QSYS2 type *N not found.

So unless something else that's V7R3-friendly shows up, I may be stuck 
with having to call QUSLJOB.

Hmm. But as it happens, I think I may have something already written 
that I can use.

--
JHHL


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

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.