RE: Monitoring Interactive Jobs for waiting message reply

Thanks Rob,

I will give this a try and see how it works out.
Did ACTIVE_JOB_INFO table come out in 7.1 or was it available in 6.1?


John


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Rob Berendt
Sent: Friday, April 08, 2016 1:08 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Monitoring Interactive Jobs for waiting message reply

Picture this interactive job:
Attempt to divide by zero (C G D F).
Type reply, press Enter.
Reply . . .



Could you somehow combine this?
SELECT JOB_NAME, JOB_STATUS
FROM TABLE (QSYS2.ACTIVE_JOB_INFO()) X where JOB_STATUS='DSPW'

JOB_NAME JOB_STATUS
...
391479/ROB/ROBS1 DSPW

with this?

SELECT ORDINAL_POSITION, MESSAGE_TYPE, MESSAGE_ID, MESSAGE_TEXT FROM
TABLE(QSYS2.JOBLOG_INFO('391479/ROB/ROBS1')) a ORDER BY
ORDINAL_POSITION DESC FETCH FIRST ROW ONLY

....+....1....+....2....+....3....+....4....+....5....+....6....+....7
....+....
ORDIN00001 MESSA00001 MESSAGE_ID MESSA00008
115 INQUIRY RNQ0102 Attempt to divide by zero
(C G
D F).
******** End of data ********

And if the message is an INQUIRY you've got a hit?

Of course, if they try to analyze it by SYS-REQ, 3 it adds job log
messages to the end.


Rob Berendt