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.

Not fully tested.....

I didn't see a DB2 service for job queue entries, but you can display it to *print.

Copy the spool file to a PF
Use the PF as a CTE (picking out the job info) for this DB2 service:
TABLE(QSYS2.JOBLOG_INFO(<job name>')) where MESSA00008 like '%<your parm here>%'

A little brute force but it should work.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power

 
 





From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxx> on behalf of Danny Hayes <Danny_Hayes@xxxxxxxxx>
Sent: Monday, April 17, 2017 1:16 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: 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.
 
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]




"This e-mail and any attachments, contain Genuine Parts Company confidential information that is proprietary, privileged, and protected by applicable laws. If you have received this message in error and are not the intended recipient, you should not retain, distribute, disclose or use any of this information and you should destroy this e-mail, any attachments or copies therein forthwith. Please notify the sender immediately by e-mail if you have received this e-mail in error."