I ran more tests, on a single job.
If the job is active
SELECT * FROM TABLE(QSYS2.JOBLOG_INFO( '824177/PAULS/PALPR5580M')) A
SELECT statement run complete.
If the job ended with an existing joblog.
SELECT * FROM TABLE(QSYS2.JOBLOG_INFO( '824177/PAULS/PALPR5580M')) A
Query cannot be run. See lower level messages.
Run in debug mode for performance information.
Job log not displayed or listed because job has ended.
User-defined function error on member QSQPTABL.
Cancel reply received for message CPF503E.
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Musselman, Paul
Sent: Thursday, August 30, 2018 10:57 AM
To: Midrange Systems Technical Discussion
Subject: RE: Is there a system a catalog that will check multiple jobs joblog for a specific message id?
Not a real-time solution-- but if the job has already ended wouldn't the QHST log still have the message? (I know it keeps job beginning and ending messages)
Paul E Musselman
PaulMmn@xxxxxxxxxxxxx
-----Original Message-----
Rob wrote (in part):
...
Is it possible that between the time you used the service to get the list
of active jobs, and the time the service to retrieve it's joblog ran,
the job completed and left no joblog? Or even worse, left it's joblog in
a spool file instead of pending?
Rob Berendt
http://amzn.to/2dEadiD
midrange.com
