Column Name | Data Type | Description |
CLIENT_ID | NUMBER | Foreign key to apt_v_server for the client |
CLIENT_NAME | STRING | Name of the client being backed up |
DURATION | STRING | Duration in time format: 00:00:00:00 |
DURATION_SECS | NUMBER | Duration in seconds |
FINISH_DATE | DATE | Date/time the job completed |
IS_ACTIVE | STRING | Is active: Y or N |
JOB_BITFLAGS | RAW | Job bit flags. This field can be “ORed” to represent the following bitwise values: Bit 0 = Manually started job Bit 1 = Compressed backup job Bit 2 = DB compressed backup job Bit 3 = Encrypted backup job, Raw |
JOB_ID | NUMBER | Foreign key to apt_v_gen_job for the client being backed up. For NetBackup, the foreign key to apt_v_nbu_job. For TSM, the foreign key to apt_v_tsm_job. This is the internal job ID and NOT the same as the backup product Job ID. |
JOB_TYPE_NAME | STRING | Job type names, as listed above |
JOB_TYPe | NUMBER | 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 | NUMBER | Enumerated type with the following possible values: 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 | NUMBER | 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 | NUMBER | 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 ,Number |
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 | STRING | Media Type |
NBR_OF_FILES | NUMBER | Number of files affected by the job |
PRODUCT_TYPE | NUMBER | Enumerate 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 | Name, as listed above |
SERVER_ID | NUMBER | Foreign key to apt_v_server for the backup server |
SERVER_NAME | STRING | Server name |
START_DATE | DATE | Start date |
SUMMARY_STATUS | NUMBER | Enumerated field with the following possible 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 names |
VENDOR_STATUS | NUMBER | Native backup product status code |
VENDOR_STATUS_NAME | STRING | Native backup product status name |