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.

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

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?

First, get a list of all the jobs in the queue. The QUSLJOB API can
list them but you'll have to filter through the job queues you want
within the program. The QGYOLJOB API lets you filter as you request the
list, so that may be a better choice for this chore. Alternately:
select job_name from table(job_info(job_status_filter => '*JOBQ')) x
where job_queue_name = 'QBATCH';

Then, search the job log of each individual job. The QMHLJOBL API will
let your program search the job log of an individual job.
Alternatively: select message_text from
table(joblog_info('244637/buck/dannytest')) x;

The SQL services are documented in DeveloperWorks
https://www.ibm.com/developerworks/community/wikis/home?lang=en#/wiki/IBM%20i%20Technology%20Updates/page/IBM%20i%20Technology%20Updates

I went to SQL Services
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/DB2%20for%20i%20-%20Services