• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

Report of Completed Jobs

 8 Replies
 2 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
hussey1213
Basic Member Send Private Message
Posts: 16
Basic Member
3/28/2018 12:39 PM
Does anyone know if there is a way to get a dump/report of Completed user jobs? We're trying to perform some job analysis; determine run times, number of times users are running jobs, etc. In LID I can copy from Completed Jobs in jobschd manually but that's going to be time consuming. Any help would be greatly appreciated.

Thank you.
Todd Mitchell
Veteran Member Send Private Message
Posts: 87
Veteran Member
3/28/2018 12:50 PM
You can try something like this:
rngdbdump -ntc gen queuedjob -v status=0 username=$userName jobname=$jobName
Kwane McNeal
Veteran Member Send Private Message
Posts: 479
Veteran Member
3/28/2018 12:53 PM
Todd is correct, though if you want completed jobs, you’ll need the status to be 63. I believe zero (0) is for running jobs.

hussey1213
Basic Member Send Private Message
Posts: 16
Basic Member
3/28/2018 1:02 PM
rngdbdump -ntc gen queuedjob -v status=63 username=$userName jobname=$jobName

Would this command only be for an indivdual user's jobs? I'm hoping to get information for all users
Todd Mitchell
Veteran Member Send Private Message
Posts: 87
Veteran Member
3/28/2018 1:04 PM
Yes, sorry:
# Known Job Statuses:
# Code Meaning
# 0 - Running
# 30 - Waiting
# 31 - Waiting Step
# 32 - Waiting On Time
# 33 - Waiting Recovery
# 34 - Needs Recovery
# 35 - Invalid Parameters
# 36 - Queue Inactive
# 37 - On Hold
# 60 - Recurring Skipped
# 61 - Recovery Deleted
# 62 - Cancelled
# 63 - Normal Completion
# 80 - ??
Todd Mitchell
Veteran Member Send Private Message
Posts: 87
Veteran Member
3/28/2018 1:06 PM
rngdbdump -ntc gen queuedjob -v status=63

Todd Mitchell
Veteran Member Send Private Message
Posts: 87
Veteran Member
3/28/2018 1:09 PM
Keep in mind though that this will produce a lot of data depending on how often you run your purge (deljobhst).
Kwane McNeal
Veteran Member Send Private Message
Posts: 479
Veteran Member
3/28/2018 1:09 PM
And for your list, there’s a more completely list, let me find it...
Status 80 is the control record... it stores the last job number. It must always exist.

hussey1213
Basic Member Send Private Message
Posts: 16
Basic Member
3/28/2018 1:18 PM
Extremely helpful, thank you all!!!!