USE msdb ;
GO

EXEC sp_add_schedule
    @schedule_name = N'DAILY 5:00 UTC' ,
    @freq_type = 4,
    @freq_interval = 1,
    @active_start_time = 050000 ;
GO

EXEC sp_add_schedule
    @schedule_name = N'DAILY 6:00 UTC' ,
    @freq_type = 4,
    @freq_interval = 1,
    @active_start_time = 060000 ;
GO

EXEC sp_add_schedule
    @schedule_name = N'SUN/WED 4:00 UTC' ,
    @freq_type = 8,
    @freq_interval = 9,
    @freq_recurrence_factor = 1,
    @active_start_time = 040000 ;
GO

EXEC sp_add_schedule
    @schedule_name = N'EVERY 15 MINUTES' ,
    @freq_type = 4,
    @freq_interval = 1,
    @freq_subday_type = 0x4,
    @freq_subday_interval = 15 ;
GO

EXEC sp_add_schedule
    @schedule_name = N'SUN 7:00 UTC' ,
    @freq_type = 8,
    @freq_interval = 1,
    @freq_recurrence_factor = 1,
    @active_start_time = 070000 ;
GO

EXEC sp_add_schedule
    @schedule_name = N'SUN 5:30 UTC' ,
    @freq_type = 8,
    @freq_interval = 1,
    @freq_recurrence_factor = 1,
    @active_start_time = 053000 ;
GO

EXEC sp_add_schedule
    @schedule_name = N'DAILY 7:05 UTC' ,
    @freq_type = 4,
    @freq_interval = 1,
    @freq_recurrence_factor = 1,
    @active_start_time = 070500 ;
GO

-- attaches the schedule to the jobs
EXEC sp_attach_schedule
   @job_name = N'DatabaseIntegrityCheck - SYSTEM_DATABASES',
   @schedule_name = N'DAILY 5:00 UTC' ;
GO

EXEC sp_attach_schedule
   @job_name = N'DatabaseIntegrityCheck - USER_DATABASES',
   @schedule_name = N'DAILY 6:00 UTC' ;
GO

EXEC sp_attach_schedule
   @job_name = N'IndexOptimize - USER_DATABASES',
   @schedule_name = N'SUN/WED 4:00 UTC' ;
GO

EXEC sp_attach_schedule
   @job_name = N'DatabaseBackup - USER_DATABASES - LOG',
   @schedule_name = N'EVERY 15 MINUTES' ;
GO

EXEC sp_attach_schedule
   @job_name = N'DatabaseBackup - USER_DATABASES - FULL',
   @schedule_name = N'SUN 7:00 UTC' ;
GO

EXEC sp_attach_schedule
   @job_name = N'DatabaseBackup - USER_DATABASES - DIFF',
   @schedule_name = N'DAILY 7:05 UTC' ;
GO

EXEC sp_attach_schedule
   @job_name = N'DatabaseBackup - SYSTEM_DATABASES - FULL',
   @schedule_name = N'SUN 5:30 UTC' ;
GO