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} 78