Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment