Who's On?

	Membership:
	Latest: John Bonin
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5270

	People Online:
	Visitors: 340
	Members: 0
	Total: 340

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

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 Send Private Message

Posts: 538

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 Send Private Message

Posts: 80

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: 3351

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