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

Rob,

SELECT * FROM TABLE(QSYS2.JOBLOG_INFO('123456/noname/jobisdone')) A
Results in same error.

Query cannot be run. See lower level messages.
Message ID . . . . . . : CPF503E
Date sent . . . . . . : 08/30/18 Time sent . . . . . . : 10:55:28

Message . . . . : User-defined function error on member QSQPTABL.

Cause . . . . . : An error occurred while invoking user-defined function
JOBLOG_INFO in library QSYS2. The error occurred while invoking the
associated external program or service program QDBSSUDF2 in library QSYS,
program entry point or external name QSQJOBLOG, specific name QSQJOBLOG. The
error occurred on member QSQPTABL file QSQPTABL in library QSYS2. The error
code is 1. The error codes and their meanings follow:
1 -- The external program or service program returned SQLSTATE 42704. The
text message returned from the program is: JOB 123456/noname/jobisdone NOT
FOUND .

Paul


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Thursday, August 30, 2018 9:38 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?

Try this
SELECT * FROM TABLE(QSYS2.JOBLOG_INFO('123456/noname/jobisdone')) A;
Do you get the same 42704? I do. Why are you getting it with
808966/QSECOFR/QUMEPRVAGT?
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