Debian Codegraph @

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

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