Re: Using SQL's JOB information queries - how can I see the command used on a submitted job?

Le 22/01/2022 à 18:00, a4g atl a écrit :

I looked the the details and it does not have the
full command with the parms. It has the program names only.

Not sure to understand what you mean. Here is the joblog:

                             Display All Messages
System:   PUB400
Job . . :   CALL          User . . :   DIMARCO       Number . . . :   885331

 >> CALL PGM(PROGRAM) PARM(PARAMETER1 PARAMETER2)
    Program PROGRAM in library *LIBL not found.
    Error found on CALL command.
    Job ended. Cancel message received at command processor.
    Job 885331/DIMARCO/CALL ended on 01/22/22 at 17:45:44; 0,007 seconds used;
      end code 20 .


And here is the SQL statement output:

SELECT A.MESSAGE_TEXT FROM
TABLE(QSYS2.JOBLOG_INFO('885331/DIMARCO/CALL')) A WHERE
A.MESSAGE_TYPE = 'REQUEST';

using iACS
MESSAGE_TEXT
CALL PGM(PROGRAM) PARM(PARAMETER1 PARAMETER2)

using STRSQL
MESSA00008
CALL PGM(PROGRAM) PARM(PARAMETER1 PARAMETER2)