Sun N1 Grid Engine 6.1 User's Guide

sge_job_log

The sge_job_log table contains job logging information.

Column 

Type 

Description 

jl_id 

Integer 

Unique record identifier 

jl_parent 

integer 

Reference to sge_job table 

jl_time 

unix timestamp 

Time when the job login entry was generated. 

jl_event 

text 

 

jl_job_number 

integer 

 

jl_task_number 

integer 

 

jl_pe_task_id 

text 

 

jl_state 

text 

job state after the reported event 

jl_user 

text 

user who initiated action for the event 

jl_host 

text 

host on which the event action was initiated 

jl_state_time 

unix timestamp 

describes, how long the job was in a certain state, see description below 

jl_message 

text 

a message explaining what happened