PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/14/2019 11:09 AM by  JimY
Create a listing of all Lawson jobs
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
GCAMM84
System Administrator
Rotary Corporation
Basic Member
(23 points)
Basic Member
Posts:9


Send Message:

--
11/08/2019 3:40 PM

    We run on an IBMi V7R2.
    We are attempting to clean out our scheduled/recurring jobs and change any that are set up to be run by user's profile name to a generic profile name so that when an employee leaves we don't have to fix these before we can delete the user profile.
    Is there a way to get a listing of all of the scheduled/recurring jobs along with their parameters as well as who runs the job?

     

    Thanks!

    Greg Moeller
    Private
    Private
    Veteran Member
    (4025 points)
    Veteran Member
    Posts:1433


    Send Message:

    --
    11/08/2019 4:00 PM
    If you have access to LID

    you can always do a "rngdbdump gen recurjob -f Username Jobname Jobqueue"  (without the quotes)

    If no, you can write a Crystal report to dump same information.  The parameters are not that easy to get.

    They exist in the gen database, but can be scattered in a field.

    JimY
    Private
    Private
    Veteran Member
    (1426 points)
    Veteran Member
    Posts:506


    Send Message:

    --
    11/11/2019 5:57 AM
    In LID from the command line you can also run recrpt with the user field blank and it will give you a listing of all the users. You can then send it to a file.
    GCAMM84
    System Administrator
    Rotary Corporation
    Basic Member
    (23 points)
    Basic Member
    Posts:9


    Send Message:

    --
    11/14/2019 9:54 AM

    Greg Moeller, is there a way to use this command in LID to view all jobs for all users instead of having to input a specific user or job?

     

    JimY, I used the recrpt in LID and it didn't return any jobs even after pressing F3 to select "All Users". 

     

    Thank you guys so very much for your help!!

    Greg Moeller
    Private
    Private
    Veteran Member
    (4025 points)
    Veteran Member
    Posts:1433


    Send Message:

    --
    11/14/2019 10:07 AM
    GCAMM84: The command I gave you will do what you are asking for- The -f just specifies that fields that you want... you could dump the entire table if you wanted to by rngdbdump gen recurjob --- but that gives you every field in the table.
    Jeff Shumate
    Private
    Private
    Advanced Member
    (93 points)
    Advanced Member
    Posts:31


    Send Message:

    --
    11/14/2019 10:07 AM
    I like using jobdump in summary. as in jobdump -o Job

    JimY
    Private
    Private
    Veteran Member
    (1426 points)
    Veteran Member
    Posts:506


    Send Message:

    --
    11/14/2019 11:09 AM
    I delete the user name and then select all users. That works for me. We are on environment version 10.0.9.
    You are not authorized to post a reply.