JobRunLog table

The JobRunLog table contains all the events that are emitted by the job runs in the JobRun table that match the monitoring configuration settings.

Table 1. JobRunLog table
Column name Column type code Description
RUNID SK The foreign key to the job run in the JobRun table for the run that emitted this log.
EventId Int A number that can be used to sort log events for a run. The EventId is not necessarily the event number found in the RT_LOG file.

The combination of RUNID and EventID is unique.

LogTimestamp Tim The time, to the nearest second, when the log event was emitted by the run.
LogType Ref The message type of the log event. See the LogTypeRef view for possible values.
MessageID 24 The ID string for the message. For example, IIS-DSEE-TFSC-00010 or IIS-DSTAGE-RUN-I-0158.
ContentType 24 Used to indicate that certain messages have special significance. The values that appear in this column are set up in the configuration file using the CaptureLog option.
MessageText Txt The full text of the logged message.