VanillaGranilla

ScheduleMaintenanceJobs.sql

Apr 28th, 2016
363
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 2.14 KB | None | 0 0
  1. USE msdb ;
  2. GO
  3.  
  4. EXEC sp_add_schedule
  5.     @schedule_name = N'DAILY 5:00 UTC' ,
  6.     @freq_type = 4,
  7.     @freq_interval = 1,
  8.     @active_start_time = 050000 ;
  9. GO
  10.  
  11. EXEC sp_add_schedule
  12.     @schedule_name = N'DAILY 6:00 UTC' ,
  13.     @freq_type = 4,
  14.     @freq_interval = 1,
  15.     @active_start_time = 060000 ;
  16. GO
  17.  
  18. EXEC sp_add_schedule
  19.     @schedule_name = N'SUN/WED 4:00 UTC' ,
  20.     @freq_type = 8,
  21.     @freq_interval = 9,
  22.     @freq_recurrence_factor = 1,
  23.     @active_start_time = 040000 ;
  24. GO
  25.  
  26. EXEC sp_add_schedule
  27.     @schedule_name = N'EVERY 15 MINUTES' ,
  28.     @freq_type = 4,
  29.     @freq_interval = 1,
  30.     @freq_subday_type = 0x4,
  31.     @freq_subday_interval = 15 ;
  32. GO
  33.  
  34. EXEC sp_add_schedule
  35.     @schedule_name = N'SUN 7:00 UTC' ,
  36.     @freq_type = 8,
  37.     @freq_interval = 1,
  38.     @freq_recurrence_factor = 1,
  39.     @active_start_time = 070000 ;
  40. GO
  41.  
  42. EXEC sp_add_schedule
  43.     @schedule_name = N'SUN 5:30 UTC' ,
  44.     @freq_type = 8,
  45.     @freq_interval = 1,
  46.     @freq_recurrence_factor = 1,
  47.     @active_start_time = 053000 ;
  48. GO
  49.  
  50. EXEC sp_add_schedule
  51.     @schedule_name = N'DAILY 7:05 UTC' ,
  52.     @freq_type = 4,
  53.     @freq_interval = 1,
  54.     @freq_recurrence_factor = 1,
  55.     @active_start_time = 070500 ;
  56. GO
  57.  
  58. -- attaches the schedule to the jobs
  59. EXEC sp_attach_schedule
  60.    @job_name = N'DatabaseIntegrityCheck - SYSTEM_DATABASES',
  61.    @schedule_name = N'DAILY 5:00 UTC' ;
  62. GO
  63.  
  64. EXEC sp_attach_schedule
  65.    @job_name = N'DatabaseIntegrityCheck - USER_DATABASES',
  66.    @schedule_name = N'DAILY 6:00 UTC' ;
  67. GO
  68.  
  69. EXEC sp_attach_schedule
  70.    @job_name = N'IndexOptimize - USER_DATABASES',
  71.    @schedule_name = N'SUN/WED 4:00 UTC' ;
  72. GO
  73.  
  74. EXEC sp_attach_schedule
  75.    @job_name = N'DatabaseBackup - USER_DATABASES - LOG',
  76.    @schedule_name = N'EVERY 15 MINUTES' ;
  77. GO
  78.  
  79. EXEC sp_attach_schedule
  80.    @job_name = N'DatabaseBackup - USER_DATABASES - FULL',
  81.    @schedule_name = N'SUN 7:00 UTC' ;
  82. GO
  83.  
  84. EXEC sp_attach_schedule
  85.    @job_name = N'DatabaseBackup - USER_DATABASES - DIFF',
  86.    @schedule_name = N'DAILY 7:05 UTC' ;
  87. GO
  88.  
  89. EXEC sp_attach_schedule
  90.    @job_name = N'DatabaseBackup - SYSTEM_DATABASES - FULL',
  91.    @schedule_name = N'SUN 5:30 UTC' ;
  92. GO
Advertisement
Add Comment
Please, Sign In to add comment