How to tell if a job posted successfully i.e. GL165

 9 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Frank
Basic Member Send Private Message
Posts: 6
Basic Member
I am trying to find out if a user for example runs GL165 in update mode, that it posted successfully? I can't seem to find any information like this? Thanks Frank
Deleted User
New Member Send Private Message
Posts: 0
New Member
A little unclear. If the job completes successfully, then it ran fine. You should also see that the gltransrel records for the run group have been deleted.
Frank
Basic Member Send Private Message
Posts: 6
Basic Member
Sorry about being unclear, since we are a public company, our auditors want to know when the users run a job i.e. GL165 in update mode, was it successfull. I believe your information will help me. Thanks for your time. Frank
Joseph Carfagno
Basic Member Send Private Message
Posts: 10
Basic Member
You may want to run queries against the Gen table QUEUEDJOB where the Token = GL165 (or GL190 or whatever else the auditors are interested in). The Status field value of 63 indicates the job completed successfully. The Lawson/Infor Knowledgebase has a complete list of the meaning of the various Statuses.
Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member
If your job ran successfully that is GL165 ran then there will be no entries on GL65 for this run group. If it ran successfully the GL jes will be sitting on GL40 and you can inquire on the run group to see this entry on GL40. You can also run a GL240 to get more information on the jes to see if it is in GL40. Other wise you can find the released je on GL95 by inquiring either on unreleased, released or posted statuses of the journal entries. Hope this helps.
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
QUEUEDJOB would be the table that you're interested in. Some clarification though. Here we are using an Oracle database and the field R_STATUS is stored in the hex equivalent to 63 --- 3F
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
If you are an Oracle shop, this may help: [code]select trim(username), trim(jobname), trim(token), to_number(r_status, 'xx'), actstartdate from queuedjob where actstartdate between (to_date('20131001', 'yyyymmdd')) and (to_date('20131003', 'yyyymmdd')) [/code]
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
So those ' are actually supposed to be '
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
Let's try this again.. those
'
are supposed to be '
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
Ok, I had a little time today... so I wrote a report to gather some of this information. Please feel free to use and modify.
Attachments