Who's On?

	Membership:
	Latest: Chris Radcliffe
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5187

	People Online:
	Visitors: 231
	Members: 0
	Total: 231

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

Tables that contains jobs that users have run

Sort:

You are not authorized to post a reply.

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

Terry P

Veteran Member

Posts: 234

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

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

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.

You are not authorized to post a reply.