Storage Viewer for Backup Database Views > apt_v_nbu_schedule
  
Version 10.0.01
apt_v_nbu_schedule
The apt_v_nbu_schedule view contains a single row for each NetBackup schedule. The schedules represented within this view can be frequency or calendar based schedules as represented by the selection_type field.
Table 3.128 apt_v_nbu_schedule
Column Name
Data Type
Description
day_of_month
RAW
This field contains a bit mask where each bit reflects what days of a month a calendar based schedule will execute. The following is a list of the bit patterns within this bit mask:
Bits 0-6 = Week 1, Sun-Sat
Bits 7-13 = Week 2, Sun-Sat
Bits 14-20 = Week 3, Sun-Sat
Bits 21-27 = Week 4, Sun-Sat
Bits 28-34 = Week 5, Sun-Sat
day_of_month_text
STRING
Text for days of a month a calendar based schedule will execute
day_of_week
RAW
This field contains a bit mask where each bit reflects what days of a week a calendar based schedule will execute. The following is a list of the bit patterns within this bit mask:
0 = Every Sunday
1 = Every Monday
2 = Every Tuesday
3 = Every Wednesday
4 = Every Thursday
5 = Every Friday
6 = Every Saturday
day_of_week_text
STRING
Text of days of a week a calendar based schedule will execute
end_of_month
CHAR
Y=Yes, N=No. This field will reflect the end of month flag that can be set for Calendar based schedules
exclude_dates
ARRAY
This field contains a list of DATE data types
exists_in_catalog
STRING
Y/N - Indicates if the schedule exists in the catalog
frequency
NUMBER
For frequency-based schedules, this is the interval (in seconds) between successive occurrences of the schedule
fri_end
STRING
Weekly schedule, Friday end time
fri_start
STRING
Weekly schedule, Friday start time
include_dates
ARRAY
This field contains a list of DATE data types
last_day_of_month
RAW
This field contains a bit mask where each bit reflects what last day of each month a calendar based schedule will execute. The following is a list of the bit patterns within this bit mask:
0 = Last Sunday of any month
1 = Last Monday of any month
2 = Last Tuesday of any month
3 = Last Wednesday of any month
4 = Last Thursday of any month
5 = Last Friday of any month
6 = Last Saturday of any month
last_day_of_month_text
STRING
Text for last day of each month a calendar-based schedule will execute
lifecycle_policy_id
NUMBER
Lifecycle policy ID
max_multiplex
NUMBER
NetBackup maximum multiplexing setting for this schedule
mon_end
STRING
Weekly schedule, Monday end time
mon_start
STRING
Weekly schedule, Monday start time
number_of_copies
NUMBER
Number of copies that will be made of any backup that uses this schedule.
policy_id
NUMBER
Foreign key to apt_v_nbu_policy.
retention_days
NUMBER
The number of days to keep the data for backups performed using this schedule. If the value is “9999”, this implies that the retention days is “infinite”
retry_after_runday
CHAR
Y=Yes, N=No. This field will reflect the retry after runday flag that can be set for Calendar based schedules
sat_end
STRING
Weekly schedule, Saturday end time
sat_start
STRING
Weekly schedule, Saturday start time
schedule_id
NUMBER
Foreign key to apt_v_nbu_schedule.
schedule_name
STRING
Name of the schedule
schedule_type
NUMBER
The enumeration type of the policy can be any of the following:
NetBackup 5.1
0=Full Backup
1=Cumulative Incremental Backup
2=Application Backup
3=Differential Incremental Backup
4=Archive
NetBackup 6.5
0=Full Backup
1=Differential Incremental Backup
2=Application Backup
3=Cumulative Incremental Backup
4=Archive
schedule_type_name
STRING
Schedule type name
selection_type
NUMBER
The enumeration type of the policy can be any of the following:
1=Frequency based schedule
2=Calendar based schedule
server_group_name
STRING
Server group name
start_window
ARRAY
This field contains an array/list of custom objects of type: weeklyScheduleType. The weeklyScheduleType type contains the following 14 attributes:
sunWindowStart (number)
sunWindowFinish (number)
monWindowStart (number)
monWindowFinish (number)
tueWindowStart (number)
tueWindowFinish (number)
wedWindowStart (number)
wedWindowFinish (number)
thuWindowStart (number)
thuWindowFinish (number)
friWindowStart (number)
friWindowFinish (number)
satWindowStart (number)
satWindowFinish (number)
storage_unit_id
NUMBER
Foreign key to apt_v_nbu_schedule_log.
sun_end
STRING
Weekly schedule, Sunday end time
sun_start
STRING
Weekly schedule, Sunday start time
synthetic
STRING
Is Synthetic? = Y or N
thu_end
STRING
Weekly schedule, Thursday end time
thu_start
STRING
Weekly schedule, Thursday start time
tue_end
STRING
Weekly schedule, Tuesday end time
tue_start
STRING
Weekly schedule, Tuesday start time
volume_pool_id
NUMBER
Foreign key to apt_v_nbu_volume_pool.
volume_pool_name
STRING
Name of the volume pool
wed_end
STRING
Weekly schedule, Wednesday end time
wed_start
STRING
Weekly schedule, Wednesday start time