Re: Print scheduled jobs details for jobs in a jobq

The closest I can see is the JOB_INFO table function in DB2 services:

https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/rzajq/rzajqudfjobinfo.htm

Use JOB_STATUS_FILTER => '*JOBQ' and you should get only the job queue entries.  I'm not sure the result table has what you need, but it's a starting point.  I think, though, that in order to get the command to run that you'll need to scan through the job log using the JOBLOG_INFO table:

https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/rzajq/rzajqudfjobloginfo.htm

It's in the variable MESSAGE_TEXT.  To read it (especially in STRSQL) remember to cast the variable returned as CHAR.




On 1/25/2019 8:48 AM, Steinmetz, Paul wrote:

Is there a command or tool that will print the schedule date, schedule time, command to run for jobs scheduled in a jobq.
We are migrating from a P7 to P9, and these cannot be saved/restored, will be lost, need to be manually reentered on new system.

Thank You
_____
Paul Steinmetz
IBM i Systems Administrator

Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071

610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home

psteinmetz@xxxxxxxxxx
http://www.pencor.com/