CREATE TABLE [dbo].[backup_schedule]
(
[schedule_id] [varbinary] (16) NOT NULL,
[scheduler_in_start_up] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[delay_backup_process_minute] [int] NULL,
[show_count_down] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[show_progress_during_backup] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[show_progress_after_backup] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[close_progress_after_minutes] [int] NULL,
[check_for_missing_resonses] [int] NULL,
[check_server] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[monthly_day] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[monthly_hour] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[monthly_minute] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[weekly_days] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[weekly_hour] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[weekly_minute] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[daily_days] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[daily_hour] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[daily_minutes] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[hourly_days] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[hourly_start_hour] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[hourly_start_minute] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[hourly_end_hour] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[hourly_end_minute] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[n_minutes_days] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[n_minutes_start_hour] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[n_minutes_start_minute] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[n_minutes_end_hour] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[n_minutes_end_minute] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[n_minutes_interval] [int] NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL,
[idle_time_minute] [int] NULL,
[capture_every_restart] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[schedule_type] [int] NULL,
[managed_type] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[fixed_year] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[fixed_month] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[fixed_day] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[fixed_hour] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[fixed_minute] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[retry_times] [int] NULL,
[retry_interval] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[backup_schedule] ADD CONSTRAINT [XPKbackup_schedule] PRIMARY KEY CLUSTERED ([schedule_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[backup_schedule] TO [backup_admin_group]
GRANT INSERT ON  [dbo].[backup_schedule] TO [backup_admin_group]
GRANT DELETE ON  [dbo].[backup_schedule] TO [backup_admin_group]
GRANT UPDATE ON  [dbo].[backup_schedule] TO [backup_admin_group]
GRANT SELECT ON  [dbo].[backup_schedule] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[backup_schedule] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[backup_schedule] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[backup_schedule] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[backup_schedule] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[backup_schedule] TO [dms_backup_group]
GRANT INSERT ON  [dbo].[backup_schedule] TO [dms_backup_group]
GRANT DELETE ON  [dbo].[backup_schedule] TO [dms_backup_group]
GRANT UPDATE ON  [dbo].[backup_schedule] TO [dms_backup_group]
GO