Debian Codegraph @

manuals/en/developers/t-dev-dbjob.tex

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