• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Tables that contains jobs that users have run

 7 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Frank
Basic Member Send Private Message
Posts: 6
Basic Member
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 Send Private Message
Posts: 80
Veteran Member
9/27/2013 3:38 PM
That information is in GEN.QUEUEDJOBS
EricS
Veteran Member Send Private Message
Posts: 80
Veteran Member
9/27/2013 3:38 PM
That information is in GEN.QUEUEDJOBS
Terry P
Veteran Member Send Private Message
Posts: 234
Veteran Member
9/27/2013 3:49 PM
Is GEN only for Landmark only? I didn't see anything like that in LOGAN.
Woozy
Veteran Member Send Private Message
Posts: 709
Veteran Member
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.
Kelly Meade
J. R. Simplot Company
Boise, ID
Woozy
Veteran Member Send Private Message
Posts: 709
Veteran Member
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.
Kelly Meade
J. R. Simplot Company
Boise, ID
mikeP
Veteran Member Send Private Message
Posts: 151
Veteran Member
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 Send Private Message
Posts: 6
Basic Member
9/27/2013 4:27 PM
Thank you all for this information.