× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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/



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.