×
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 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.