Storage Viewer for Backup Database Views > apt_v_nbu_job_detail
  
Version 10.0.01
apt_v_nbu_job_detail
The apt_v_nbu_job_detail view contains a one row for each NetBackup job try. This view is specific for Veritas NetBackup environments. A row is inserted into this view when a job is first created (or soon thereafter) and updated as the status of the job changes over time.
Table 3.111 apt_v_nbu_job_detail
Column Name
Data Type
Description
backup_id
STRING
Veritas NetBackup Backup ID. This is sometimes referred to as the image ID. This is the unique backup identified that has the format <client_name>_<timestamp>
client_host_name
STRING
Name of the client.
client_id
NUMBER
Foreign key to apt_v_server for the NetBackup client.
duration
STRING
Duration in Hour, Minute, Second format
duration_secs
NUMBER
Duration in seconds
expiration_date
DATE
For backup jobs, this is the date/time when the underlying Veritas NetBackup image will expire
finish_date
DATE
Date/time that the job completed
finished_readwrite
DATE
Date/time that the job try finished read/write.
is_active
CHAR
Y=Yes, No=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
Foreign key to apt_v_nbu_job.
This is the Hitachi Storage Viewer internal job ID and NOT the same as the NetBackup Job ID.
job_type
NUMBER
Enumeration field with the following possible values:
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 name 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
lifecycle_policy_id
NUMBER
lifecycle_policy_name
STRING
Storage lifecycle policy name
lifecycle_policy_version
NUMBER
Storage lifecycle policy name
master_host_name
STRING
Name of the master server
mbytes_sec
NUMBER
Megabytes per second
media_host_name
STRING
Name of the media server
media_server_id
NUMBER
Foreign key to apt_v_server for the media server.
media_type
CHAR
D=Disk based backup, T=Tape based backup
nbr_of_copies
NUMBER
For NetBackup backup jobs, this field contains the number of copies that were made of the backup
nbr_of_files
NUMBER
Number of files affected by the NetBackup job
nbu_job_id
NUMBER
Veritas NetBackup Job ID
parent_job_id
NUMBER
parent_nbu_job_id
NUMBER
Veritas NetBackup Parent Job ID. This is normally NULL but may exist for certain parent/child jobs such as multi-streaming jobs or database backup jobs
parent_schedule_name
STRING
Parent schedule name
policy_id
NUMBER
Foreign key to apt_v_nbu_policy.
policy_name
STRING
Name of the policy.
policy_type_name
STRING
Name of the policy type
product_type_name
STRING
Product type name
sched_start_date
DATE
For a backup job, this is the date/time that the job was scheduled to start
schedule_id
NUMBER
Foreign key to apt_v_nbu_schedule.
schedule_name
STRING
Name of the schedule
schedule_type_name
STRING
Name of the schedule type
server_id
NUMBER
Foreign key to apt_v_server for the NetBackup master server.
start_date
DATE
Date/time that the job started
started_readwrite
DATE
Date/time that the job try started read/write.
storage_unit_id
NUMBER
Foreign key to apt_v_nbu_storage_unit.
storage_unit_label
STRING
Label for the storage unit
stream_index
NUMBER
Veritas NetBackup stream index for multi-streaming jobs. This column is normally 0 for non-multi-streaming jobs
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. If the job was a backup and the summary status was 1 (partial), this is a result of NetBackup skipping some of the files in a backup
target_client_id
NUMBER
Foreign key to apt_v_server for the target client.
This field should only be used for restore jobs and contains the target client for a restore (i.e., Destination client). The client_id column above is the source and the server_id is the media server that performed the restore
try_count
NUMBER
For backup jobs, this field contains the number of tries or attempts of the backup job
try_finish_date
DATE
Date/time that the job try completed
try_start_date
DATE
Date/time that the job try started
try_status
NUMBER
Native NetBackup status code for each try
vendor_state
NUMBER
Native NetBackup job state codes. This is an enumeration field with the following values:
0 = Job is queued
1 = Job is running / in-process
2 = Job has been re-queued
3 = Job has been closed / completed
4 = Job has been closed / deleted
5 = No client software installed
6 = Job is pending
vendor_state_name
STRING
Name associated with the above state
vendor_status
NUMBER
Native NetBackup status code
vendor_status_name
STRING
Name associated with the status code