• 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
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
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
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
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
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
Posts: 87
Veteran Member
3/28/2018 1:06 PM
rngdbdump -ntc gen queuedjob -v status=63

Todd Mitchell
Veteran Member
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
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
Posts: 16
Basic Member
3/28/2018 1:18 PM
Extremely helpful, thank you all!!!!