1 \begin{longtable}{|l|l|X|}
2 \caption{Job History Table Layout}\label{table:dbjobhistory} \\
4 \multicolumn{3}{c}{Cont. on next page} \\
7 \multicolumn{1}{|c|}{\bf Column Name}
8 & \multicolumn{1}{l|}{\bf Data Type}
9 & \multicolumn{1}{l|}{\bf Remark} \\
12 \multicolumn{1}{|c|}{\bf Column Name}
13 & \multicolumn{1}{l|}{\bf Data Type}
14 & \multicolumn{1}{l|}{\bf Remark } \\
17 JobId & integer & Primary Key \\
19 Job & tinyblob & Unique Job Name \\
21 Name & tinyblob & Job Name \\
23 Type & binary(1) & Job Type: Backup, Copy, Clone, Archive, Migration
26 Level & binary(1) & Job Level \\
28 ClientId & integer & Client index \\
30 JobStatus & binary(1) & Job Termination Status \\
32 SchedTime & datetime & Time/date when Job scheduled \\
34 StartTime & datetime & Time/date when Job started \\
36 EndTime & datetime & Time/date when Job ended \\
38 RealEndTime & datetime & Time/date when original Job ended \\
40 JobTDate & bigint & Start day in Unix format but 64 bits; used for
43 VolSessionId & integer & Unique Volume Session ID \\
45 VolSessionTime & integer & Unique Volume Session Time \\
47 JobFiles & integer & Number of files saved in Job \\
49 JobBytes & bigint & Number of bytes saved in Job \\
51 JobErrors & integer & Number of errors during Job \\
53 JobMissingFiles & integer & Number of files not saved (not yet used)
56 PoolId & integer & Link to Pool Record \\
58 FileSetId & integer & Link to FileSet Record \\
60 PrioJobId & integer & Link to prior Job Record when migrated \\
62 PurgedFiles & tiny integer & Set when all File records purged \\
64 HasBase & tiny integer & Set when Base Job run
66 Reviewed & tiny integer & Set when the error is acknowledged \\
68 Comment & tinyblob & Comment about this Job\\