Jose,
When I ran " select * from table(qsys2.joblog_info('jobnumber#/userid/jobname')) a" I got the following error message:
Error retrieving results SQL State: 22023 Vendor Code: -443 Message: [SQL0443] JOB jobnumber#/userid/jobname NOT VALID Cause . . . . . : Either a trigger program, external procedure, or external function detected and returned an error to SQL. If the error occurred in a trigger program, the trigger was on table QDBSSUDF2 in schema QSYS. If the error occurred in an external procedure or function, the external name is QDBSSUDF2 in schema QSYS. The associated text is JOB jobnumber#/userid/jobname NOT VALID. If the error occurred in a trigger program, the associated text is the type of trigger program. If the error occurred in an external function, the associated text is the text of the error message returned from the external function. Recovery . . . : Refer to the joblog for more information regarding the detected error. Correct the error and try the request again.
I ran this in the new ACS Run SQL Scripts app, could that be the issue, I also ran in STRSQL and also got an error -> A Query cannot be run.
Danny
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jose Perez
Sent: Monday, April 17, 2017 5:48 PM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx>
Subject: Re: Joblogs for jobs in jobq: Not sure this is the right group, but if not I am sure Mr Gibbs will point me to the right one.
Using sql to inquiry the joblog information table can be very helpful, if you run this sql statement you may get what you need
select * from table(qsys2.joblog_info('jobnumber#/userid/jobname')) a
you are going to search your parm in this column MESSAGE_TEXT like this for example
SELECT * FROM table(qsys2.joblog_info( 'JOB#/USERID/JOBNAME')) A where a.MESSAGE_TEXT like '%PARM(''ALB170401ALB053O0000''%'
Important: Do not forget the double quote PARM(''ALB170401ALB053O0000''
On Mon, Apr 17, 2017 at 4:45 PM, John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:
On Mon, Apr 17, 2017 at 4:23 PM, Paul Therrien
<paultherrien@xxxxxxxxxxxxxxxxxx> wrote:
Can you just resubmit the job to another queue? Or is there an
issue of having it run a 2nd time?
The issue is that he needs to find which job to run.
John Y.
--
This is the RPG programming on the IBM i (AS/400 and iSeries)
(RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
"This e-mail and any attachments, contain Genuine Parts Company confidential information that is proprietary, privileged, and protected by applicable laws. If you have received this message in error and are not the intended recipient, you should not retain, distribute, disclose or use any of this information and you should destroy this e-mail, any attachments or copies therein forthwith. Please notify the sender immediately by e-mail if you have received this e-mail in error."
midrange.com
