Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Report of dist groups associated with jobs

 2 Replies
 2 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Margie Gyurisin
Veteran Member
Posts: 538
Veteran Member
2/17/2016 1:47 PM

    Is there a way to see what distribution groups may be associated with job(s) via a report or dump per user or  job name?

     

    I know I can use jobprmprt to show parameters but I'd like to know if any of the jobs are automatically distributed.

     

    I hope that is clear.

     

    Thanks for your help.

    pbelsky
    Veteran Member
    Posts: 80
    Veteran Member
    2/17/2016 5:51 PM

      Hi Margie, look at the value of DSTGRP in the JOBSTEPRPT table in GEN. The GEN table DSTGRPUSER will show you the users in the dist group.

      John Henley
      Posts: 3353
      2/20/2016 2:15 AM
        from GEN database,
        SELECT JOB.JOBNAME, JOB.USERNAME, JOB.DESCRIPTION, JST.TOKEN, JSR.DSTGRP, DGP.DESCRIPTION, DGU.USERNAME
        FROM JOBSTEPRPT JSR
        INNER JOIN DSTGRP DGP
        ON DGP.DSTGRP = JSR.DSTGRP
        AND JSR.DSTGRP <> ''
        LEFT OUTER JOIN DSTGRPUSER DGU
        ON DGU.DSTGRP = DGP.DSTGRP
        INNER JOIN JOBSTEP JST
        ON JST.USERNAME = JSR.USERNAME
        AND JST.JOBNAME = JSR.JOBNAME
        AND JST.STEPKEY = JSR.STEPKEY
        INNER JOIN JOB
        ON JOB.USERNAME = JST.USERNAME
        AND JOB.JOBNAME = JST.JOBNAME
        Thanks for using the LawsonGuru.com forums!
        John