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

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.

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

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.

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.

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

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]

So those ' are actually supposed to be '

Let's try this again.. those

'

are supposed to be '

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.