Storage Viewer for Backup Database Views > apt_v_cmv_job
  
Version 10.0.01
apt_v_cmv_job
The apt_v_cmv_job view contains a single row for each Commvault job.
Table 3.48 apt_v_cmv_job
Column Name
Data Type
Description
client_id
NUMBER
Client identifier for the job
cmv_backup_policy_id
NUMBER
Backup policy identifier (Storage Viewer generated)
cmv_backupset_id
NUMBER
Backup set ID
cmv_dbinstance_id
NUMBER
Database instance ID
cmv_idataagent_id
NUMBER
iDataAgent ID
cmv_job_id_ext
NUMBER
Job identifier (Commvault generated)
cmv_primary_backup_copy_id
NUMBER
Primary backup copy identifier (Storage Viewer generated)
cmv_subclient_id
NUMBER
Subclient identifier (Storage Viewer generated)
failed_filelist_remain_attmpt
NUMBER
Failed file list remaining attempts
is_active
STRING
Flag (Yes/No) to indicate whether a Job is active or not.
is_aged
STRING
Aged flag
job_failed_reason_id
NUMBER
Job failed reason identifier (Storage Viewer generated)
job_id
NUMBER
Job identifier (Storage Viewer generated)
job_init_from
NUMBER
Job initialized from identifier (Storage Viewer generated)
job_status
NUMBER
Job status
1 - Success
2 - Failed
3 - Partial Success
4 - Killed
5 - Stopped
6 - Interrupted
7 - Unknown
8 - Failed to Start
9 - Abnormally Terminated Cleanup
10 - Completed
11 - Completed w/ one or more errors
12 - Failed
13 - Interrupt Pending
14 - Kill Pending
15 - Killed
16 - Pending
17 - Queued
18 - Running
19 - Running (Cannot be verified)
20 - Suspend Pending
21 - Suspended
22 - System Kill Pending
23 - Waiting
last_updated
DATE
Date and time last updated
nbr_of_bytes_comp
NUMBER
Number of bytes compressed
nbr_of_bytes_uncomp
NUMBER
Number of bytes uncompressed
nbr_of_corrupted_files
NUMBER
Number of corrupted files
nbr_of_directories
NUMBER
Number of directories
nbr_of_in_use_files
NUMBER
Number of in-use files
nbr_of_other_skipped_files
NUMBER
Number of other skipped files
nbr_of_streams
NUMBER
Number of streams
nbr_of_vms
NUMBER
Number of VMs used for the backup/restore job
scheduled_start_time
DATE
Scheduled start time
server_instance_id
NUMBER
Server instance identifier (Storage Viewer generated)