Re: Is there a system a catalog that will check multiple jobs joblog for a specific message id?

Select
*

From TABLE(QSYS2.ACTIVE_JOB_INFO('NO','','*ALL','')) As A

left join table(joblog_info(A.JOB_NAME)) as b
on b.MESSAGE_ID = 'CPF1124'

Jim
________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> on behalf of Rob Berendt <rob@xxxxxxxxx>
Sent: Tuesday, August 28, 2018 3:56 PM
To: Midrange Systems Technical Discussion
Subject: Re: Is there a system a catalog that will check multiple jobs joblog for a specific message id?

Perhaps some sort of join, lateral, etc of QSYS2.JOBLOG_INFO and JOB_INFO?
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzajq/rzajqudfjobinfo.htm


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 08/28/2018 03:52 PM
Subject: Is there a system a catalog that will check multiple jobs
joblog for a specific message id?
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Is there a system a catalog that will check multiple jobs joblog for a
specific message id?
I reviewed QSYS2.JOBLOG_INFO, but that works only a single job, and does
not allow you to select a message id.

Thank You
_____
Paul Steinmetz
IBM i Systems Administrator

Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071

610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home

psteinmetz@xxxxxxxxxx<mailto:psteinmetz@xxxxxxxxxx>
http://www.pencor.com/

--
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


--
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