Table 9.7: JobMedia table layout

Column Name

Data Type

Remark

JobMediaId

integer

Primary Key

JobId

integer

Link to Job Record

MediaId

integer

Link to Media Record

FirstIndex

integer

The index (sequence number) of the first file written for this Job to the Media

LastIndex

integer

The index of the last file written for this Job to the Media

StartFile

integer

The physical media (tape) file number of the first block written for this Job

EndFile

integer

The physical media (tape) file number of the last block written for this Job

StartBlock

integer

The number of the first block written for this Job

EndBlock

integer

The number of the last block written for this Job

VolIndex

integer

The Volume use sequence number within the Job