Column Name |
Data Type |
Remark |
|---|---|---|
JobId |
integer |
Primary Key |
Job |
tinyblob |
Unique Job Name |
Name |
tinyblob |
Job Name |
PurgedFiles |
tinyint |
Used by Bacula for purging/retention periods |
Type |
binary(1) |
Job Type: Backup, Copy, Clone, Archive, Migration |
Level |
binary(1) |
Job Level |
ClientId |
integer |
Client index |
JobStatus |
binary(1) |
Job Termination Status |
SchedTime |
datetime |
Time/date when Job scheduled |
StartTime |
datetime |
Time/date when Job started |
EndTime |
datetime |
Time/date when Job ended |
RealEndTime |
datetime |
Time/date when original Job ended |
JobTDate |
bigint |
Start day in Unix format but 64 bits; used for Retention period. |
VolSessionId |
integer |
Unique Volume Session ID |
VolSessionTime |
integer |
Unique Volume Session Time |
JobFiles |
integer |
Number of files saved in Job |
JobBytes |
bigint |
Number of bytes saved in Job |
ReadBytes |
bigint |
Number of bytes read in Job |
JobErrors |
integer |
Number of errors during Job |
JobMissingFiles |
integer |
Number of files not saved (not yet used) |
PoolId |
integer |
Link to Pool Record |
FileSetId |
integer |
Link to FileSet Record |
PrioJobId |
integer |
Link to prior Job Record when migrated |
PurgedFiles |
tiny integer |
Set when all File records purged |
HasBase |
tiny integer |
Set when Base Job run |
Reviewed |
tiny integer |
Set when the error is acknowledged |
Comment |
tinyblob |
Comment about this Job |
PrioJob |
tinyblob |
Prior Job name when migrated |