Prev
Next
Forums Lawson S3 Financials

Report of Completed Jobs

Sort:
You are not authorized to post a reply.
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!!!!
                    You are not authorized to post a reply.