Fw: 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.

Someone figure out a way to tie these two queries together:

SELECT X.JOB_NAME
FROM TABLE(QSYS2.JOB_INFO(JOB_STATUS_FILTER => '*JOBQ',
JOB_USER_FILTER => '*ALL')) X
WHERE JOB_QUEUE_LIBRARY = 'ERPLXEC'
AND JOB_QUEUE_NAME = 'BPCSJOBQ';

SELECT Y.MESSAGE_ID, Y.MESSAGE_TEXT
FROM TABLE(QSYS2.JOBLOG_INFO('017044/DARREN/CST601J')) Y
WHERE Y.MESSAGE_TEXT LIKE '%ERPCSTROL1DARREN%';

You need to pass x.job_name from the first query into where you see
'017044/DARREN/CST601J'

For more information see
http://ibm.biz/DB2foriServices


Rob Berendt