Column Name | Data Type | Description |
client_id | NUMBER | Foreign key to apt_v_server for the client being backed up. |
client_name | STRING | Name of the client being backed up. |
duration | STRING | Duration in Hour, Minute, Second |
duration_secs | NUMBER | Duration in seconds |
finish_date | DATE | Date/time that the job completed |
is_active | CHAR | Y=Yes, N=No |
job_bitflags | RAW | This is a bit field that can be “OR’ed” to represent the following bitwise variables: Bit 0 = Manually started job Bit 1 = Compressed backup job Bit 2 = DB compressed backup job Bit 3 = Encrypted backup job |
job_id | NUMBER | Primary key for this view. For NetBackup, the foreign key to apt_v_nbu_job. For TSM, the foreign key to apt_v_tsm_job. This is the Hitachi Storage Viewer internal job ID and NOT the same as the backup product Job ID. |
job_type | Backup Exec: 201 = Resource Discovery 202 = Backup 203 = Duplicate 204 = Catalog 205 = Report 206 = Restore 207 = Test Run 208 = Inventory Or Erase 209 = Verify 299 = Other | |
job_type | HP Data Protector: 601 = Full Backup 602 = Incremental Backup 603 = Incremental Backup 1 604 = Incremental Backup 2 605 = Incremental Backup 3 606 = Incremental Backup 4 607 = Incremental Backup 5 608 = Incremental Backup 6 609 = Incremental Backup 7 610 = Incremental Backup 8 611 = Incremental Backup 9 612 = Diff 698 = Restore 699 = Other | |
job_type | NetWorker: 301 = Full Backup 302 = Incremental Backup 303 = Migration 304 = Manual Backup 305 = Consolidate 306 = Copy 307 = Diff 308 = 1 309 = 2 310 = 3 311 = 4 312 = 5 313 = 6 314 = 7 315 = 8 316 = 9 317 = Restore 399 = Other | |
job_type | Tivoli Storage Manager: 401 = Selective Backup 402 = Incremental Backup 403 = Image Backup 404 = Archive 405 = Restore 406 = Image Restore 407 = Retrieve 408 = Command 409 = Macro 410 = Migration 411 = Reclamation 412 = Full DB Backup 413 = Incremental DB Backup 414 = Stg. Pool Backup 415 = Expiration 416 = Move DR Media 417 = Move Media 418 = Backup 419 = Tape Mount 499 = Other | |
job_type | NUMBER | NetBackup: 101 = Full backup 102 = Incremental backup 103 = Catalog backup 104 = Archive 105 = Restore 106 = Verification 107 = Duplicate 108 = Import 109 = Migration 110 = Label 111 = Media Erase 112 = Application backup 199 = Other |
job_type_name | STRING | Job type names as above. |
kilobytes | NUMBER | For backup jobs, this is the number of kilobytes in the backup. For restore jobs, this is the number of kilobytes restored |
mbytes_sec | NUMBER | Megabytes per second |
media_type | CHAR | D=Disk-based backup, T=Tape-based backup |
nbr_of_files | NUMBER | Number of files affected by the job |
product_type | NUMBER | Enumeration field with the following possible values: 1 –Veritas NetBackup 2 – Veritas Backup Exec 3 – EMC NetWorker 4 – IBM Tivoli Storage Manager 5 – Commvault Simpana 6 – HP Data Protector |
product_type_name | STRING | Names as above |
server_id | NUMBER | Foreign key to apt_v_server for the Master Server. |
server_name | STRING | Master server name |
start_date | DATE | Date/time that the job started |
summary_status | NUMBER | This is an enumeration field with the following values: 0 =successful 1 = partial / warning 2 = failed / error This field can be inspected to determine the overall summary status of a job. |
vendor_state | NUMBER | Native backup product specific job state codes. |
vendor_state_name | STRING | Native backup product specific job state name. |
vendor_status | NUMBER | Native backup product status code |
vendor_status_name | STRING | Native backup product status name |