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

Tables that contains jobs that users have run

7 Replies

0 Subscribed to this topic

29 Subscribed to this forum

Sort:

Author

Messages

Frank

Basic Member

Posts: 6

9/27/2013 3:28 PM

Not sure if this can be done, but does anyone know if there are tables that contain information in which shows when a user ran a job through jobdef?
Thanks
Frank

EricS

Veteran Member

Posts: 80

9/27/2013 3:38 PM

That information is in GEN.QUEUEDJOBS

EricS

Veteran Member

Posts: 80

9/27/2013 3:38 PM

That information is in GEN.QUEUEDJOBS

Deleted User

New Member

Posts: 0

9/27/2013 3:49 PM

Is GEN only for Landmark only? I didn't see anything like that in LOGAN.

Woozy

Veteran Member

Posts: 709

New Poster

9/27/2013 4:12 PM

GEN is a prodline like Logan. It is used by LSF and Landmark, although it is not used for jobs in Landmark.

Woozy

Veteran Member

Posts: 709

New Poster

9/27/2013 4:15 PM

Note that it might be called something other than "GEN" in your environment. In ours, our dev environment has "LSFGEN" and prod environment has "GEN". On our Unix/DB2 environment, I can find this by going to $LAWDIR/gen/IBM and looking for the "SCHEMA" value. I'm guessing this is similar in other setups.

mikeP

Veteran Member

Posts: 151

9/27/2013 4:23 PM

In our SQL Server database, it's in a PGEN database, table name dbo.QUEUEDJOB.

Any have any experience accessing this data progamatically? E.g. what the status codes mean, etc.?

Frank

Basic Member

Posts: 6

9/27/2013 4:27 PM

Thank you all for this information.