Re: Joblogs for jobs in jobq: Not sure this is the right group, but if not I am sure Mr Gibbs will point me to the right one.

Danny:

Use the QGYOLJOB API to retrieve a list of the jobs in that job queue, and process each job. For an example of how to do that in RPG, see:

http://www.mcpressonline.com/programming/apis/the-api-corner-accessing-job-queue-entries

Then, use the QMHLJOBL API to retrieve the messages in each job's message queue ... For a description and example program, see:

http://itknowledgeexchange.techtarget.com/itanswers/retrieving-job-information-command-string-for-jobs-waiting-in-job-queues-on-an-iseries/

(The CL program shown is not perfect, but a "starting point"...)

Hope this helps,

Mark S. Waterbury


> On 4/17/2017 4:16 PM, Danny Hayes wrote:

I have an issue I thought one of you might have a solution for:

I have a job queue with 233,587 entries in it, all from me, it is on hold.
Each job has in its joblog the name of an order of some type.
I only want to run the job that has the one I care about, but it would take me a couple of days to display each job and check its joblog to see if it is the one.
I need some way to dump all of the joblogs into one bucket and then search all for the one I want.

each joblog looks like this: CALL PGM(*LIBL/ASN0220CL) PARM('ALB170401ALB053O0000' ' 0508000')

I want to find the one job that has ATL170408ATL050N0000 as the parameter.

Do you know of any method to accomplish this?


Thanks & Regards,
Danny Hayes
IT-Developer
Genuine Parts Company, APG IT
[APGIT_forward]