Storage Viewer for Backup Database Views > apt_v_avm_schedules
  
Version 10.0.01
apt_v_avm_schedules
The apt_v_avm_schedules view contains one row per schedule defined on an Avamar system.
Table 3.35 apt_v_avm_schedules
Column Name
Data Type
Description
avm_domain_id
NUMBER
Avamar Domain ID
description
STRING
Description of this schedule
end_date
DATE
Date at which this schedule expires
end_policy
NUMBER
Type of schedule termination setting. Valid values are:
2 - Never end
3 - Run N number of times
4 - End on a specific date
end_recurrence
NUMBER
End recurrence. If end_date is not specified, this is a count of the number of times the schedule should run or 0 if it never ends
exists_in_catalog
STRING
Indicates if the schedule is in the catalog
first_start_date
DATE
First date this schedule was used
gsan_system_id
STRING
System-generated identifier for this Avamar system
gsan_system_name
STRING
User-assigned identifier for this Avamar system
interval_mod
NUMBER
Interval mode
is_enabled
STRING
If Y, this schedule can be used
is_fixed_interval
STRING
Indicates if it is a fixed interval schedule
is_link
STRING
If Y, this schedule is an alias for another schedule
is_override_endtime
STRING
If Y, schedule end time can be overridden
is_read_only
STRING
If Y, schedule cannot be modified
last_check_date
DATE
Last schedule check date
last_start_date
DATE
Last start date
last_updated
DATE
Date and time last updated
master_server_id
NUMBER
Master server ID
parent_schedule_id
NUMBER
foreign key into apt_v_schedules_2 to locate the parent of this schedule if any
recurrence_counter
NUMBER
Number of recurrences
recurrence_interval
STRING
Recurence interval
schedule_id
NUMBER
Primary key of apt_v_avm_schedules
schedule_name
STRING
Name of this schedule
start_date
DATE
Start Date
start_duration
DATE
Duration
time_zone_id
STRING
Time zone of the server
total_duration
DATE
Total schedule duration