| 1 |
\begin{longtable}{llX} |
| 2 |
\caption{Job table layout}\label{blb:dev:job:table:layout} \\ |
| 3 |
\toprule |
| 4 |
\rowcolor{bheader} |
| 5 |
\multicolumn{1}{c}{\bheader{Column Name}} & |
| 6 |
\multicolumn{1}{l}{\bheader{Data Type}} & |
| 7 |
\multicolumn{1}{l}{\bheader{Remark}} \\ |
| 8 |
\midrule |
| 9 |
\endfirsthead |
| 10 |
\toprule |
| 11 |
\rowcolor{bheader} |
| 12 |
\multicolumn{1}{c}{\bheader{Column Name}} & |
| 13 |
\multicolumn{1}{l}{\bheader{Data Type}} & |
| 14 |
\multicolumn{1}{l}{\bheader{Remark}} \\ |
| 15 |
\midrule |
| 16 |
\endhead |
| 17 |
\midrule |
| 18 |
\multicolumn{3}{c}{\bnextpage{}} \\ |
| 19 |
\endfoot |
| 20 |
\bottomrule |
| 21 |
\endlastfoot |
| 22 |
JobId & integer & Primary Key \\ |
| 23 |
\midrule |
| 24 |
Job & tinyblob & Unique Job Name \\ |
| 25 |
\midrule |
| 26 |
Name & tinyblob & Job Name \\ |
| 27 |
\midrule |
| 28 |
PurgedFiles & tinyint & Used by Bacula for purging/retention periods \\ |
| 29 |
\midrule |
| 30 |
Type & binary(1) & Job Type: Backup, Copy, Clone, Archive, Migration \\ |
| 31 |
\midrule |
| 32 |
Level & binary(1) & Job Level \\ |
| 33 |
\midrule |
| 34 |
ClientId & integer & Client index \\ |
| 35 |
\midrule |
| 36 |
JobStatus & binary(1) & Job Termination Status \\ |
| 37 |
\midrule |
| 38 |
SchedTime & datetime & Time/date when Job scheduled \\ |
| 39 |
\midrule |
| 40 |
StartTime & datetime & Time/date when Job started \\ |
| 41 |
\midrule |
| 42 |
EndTime & datetime & Time/date when Job ended \\ |
| 43 |
\midrule |
| 44 |
RealEndTime & datetime & Time/date when original Job ended \\ |
| 45 |
\midrule |
| 46 |
JobTDate & bigint & Start day in Unix format but 64 bits; used for Retention period. \\ |
| 47 |
\midrule |
| 48 |
VolSessionId & integer & Unique Volume Session ID \\ |
| 49 |
\midrule |
| 50 |
VolSessionTime & integer & Unique Volume Session Time \\ |
| 51 |
\midrule |
| 52 |
JobFiles & integer & Number of files saved in Job \\ |
| 53 |
\midrule |
| 54 |
JobBytes & bigint & Number of bytes saved in Job \\ |
| 55 |
\midrule |
| 56 |
ReadBytes & bigint & Number of bytes read in Job \\ |
| 57 |
\midrule |
| 58 |
JobErrors & integer & Number of errors during Job \\ |
| 59 |
\midrule |
| 60 |
JobMissingFiles & integer & Number of files not saved (not yet used) \\ |
| 61 |
\midrule |
| 62 |
PoolId & integer & Link to Pool Record \\ |
| 63 |
\midrule |
| 64 |
FileSetId & integer & Link to FileSet Record \\ |
| 65 |
\midrule |
| 66 |
PrioJobId & integer & Link to prior Job Record when migrated \\ |
| 67 |
\midrule |
| 68 |
PurgedFiles & tiny integer & Set when all File records purged \\ |
| 69 |
\midrule |
| 70 |
HasBase & tiny integer & Set when Base Job run \\ |
| 71 |
\midrule |
| 72 |
Reviewed & tiny integer & Set when the error is acknowledged \\ |
| 73 |
\midrule |
| 74 |
Comment & tinyblob & Comment about this Job\\ |
| 75 |
\midrule |
| 76 |
PrioJob & tinyblob & Prior Job name when migrated \\ |
| 77 |
\end{longtable} |