RE: IBM API QGYOLJOB

["Kevin Bucknum" <Kevin@xxxxxxxxxxxxxxxxxxx>]

SELECT * FROM table(qsys2.job_info()) x WHERE job_status in
('JOBQ','ACTIVE')                                          
and job_name like ('%KEVIN%')                              

>


Kevin Bucknum
Senior Programmer Analyst
MEDDATA/MEDTRON
Tel: 985-893-2550
 
-----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf
> Of dlclark@xxxxxxxxxxxxxxxx
> Sent: Thursday, January 4, 2018 10:56 AM
> To: Midrange-L
> Subject: IBM API QGYOLJOB
>
>
>         I'm looking at IBM API QGYOLJOB.  I need to create a list of
jobs in either
> status *JOBQ or *ACTIVE that is filtered by a submitter's qualified
job name.
> I can see how to create a list of jobs with those statuses and also
return the
> associated submitter's qualified job name for each entry.  But I don't
see how
> to filter such a list by that submitter.
> We regularly have in excess of 20,000 active jobs on the system.  I
don't want
> a list of all jobs on the system and then have to search through that
list to
> find the matching submitter.  Am I missing something?  Thanks for any
hints
> or suggestions.
>
> Sincerely,
>
> Dave Clark
> --
> int.ext: 91078
> direct: (937) 531-6378
> home: (937) 751-3300
>
> Winsupply Group Services
> 3110 Kettering Boulevard
> Dayton, Ohio  45439  USA
> (937) 294-5331
>
>
>
> **********************************************************
> ***********************************
> This email message and any attachments is for use only by the named
> addressee(s) and may contain confidential, privileged and/or
proprietary
> information. If you have received this message in error, please
immediately
> notify the sender and delete and destroy the message and all copies.
All
> unauthorized direct or indirect use or disclosure of this message is
strictly
> prohibited. No right to confidentiality or privilege is waived or lost
by any
> error in transmission.
> **********************************************************
> ***********************************
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
> a moment to review the archives at
> https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD