JobLink table

The JobLink table contains the static details, that is the details of links that are set at compilation time, for all links for which events are emitted.

The JobRunLink table contains details of the use of every link in all job runs.
Table 1. JobLink table
Column name Column type code Description
LINKID SK A surrogate primary key for the link.
FROMSTAGEID SK The foreign key to the stage in the JobRunStage table for the stage that this link outputs from.
TOSTAGEID SK The foreign key to the stage in the JobRunStage table for the stage that this link inputs to.
LinkName 80 The name of the link, which is unique within the pair of stages it connects.

The combination of FROMSTAGEID, TOSTAGEID, and LinkName is unique.

LinkType Ref The type of the link. See the LinkTypeRef view for possible values.
LinkDescription Txt The description of the link.
IsSource Bool Set to True if the link is reading from an external data source.
IsTarget Bool Set to True if the link is writing to an external target.