SQL Sentry employs extensive scheduling capabilities through its Schedules and Windows features. Schedules and Windows can be managed through their respective nodes found in the Navigator pane.
Schedules has the following application within SQL Sentry:
- Fragmentation Manager Operations
Windows has the following applications within SQL Sentry:
- Maintenance Windows
- Email and Pager Windows for Users and Groups
- Ruleset Windows for Configured Actions
SQL Sentry allows you to create Schedules that can be applied in the following place:
|Fragmentation Manager Operations||Enable Fragmentation Manager in your SQL Sentry environment, and then select a schedule to perform Fragmentation Manager Operations. This schedule is initially specified in the Fragmentation Manager wizard. After enabling Fragmentation Manger for an instance, access the applied schedule through the Index Defragmentation settings found in the Settings pane (View > Settings).
Note: Index Defragmentation settings, including the applied schedule, can be configured at the following levels: All Targets (Global), site, target group, target, instance, database, table, and individual index.
Additional Information: For more information, see the Fragmentation Manager topic.
SQL Sentry allows you to create Windows that can be applied in the following places:
|Used to set a schedule for the Maintenance Window. Only Log Actions are triggered for Failsafe Conditions inside the Maintenance Window. Maintenance Window settings allow a time frame to be specified while scheduled maintenance activities take place on that instance.
Note: There are several options for configuring Maintenance Windows within SQL Sentry, including Maintenance Windows specific to targets, instances, and the SQL Sentry database.
|Email and Pager Windows for Users and Groups||Email and Pager Windows can be assigned to a user or group. Windows control the time frame of when alerts are sent to the user or group. When you assign an Email or Pager Window to a user or group, you have the option to change the Window Behavior to one of the following:
Note: To apply an Email or Pager Window to a user or group, double-click the user or group in the Navigator pane to open an Edit User/Group tab. Use the Email or Pager Window drop-down list to choose the desired Window. Use the Email or Pager Window Behavior drop-down list to choose the desired behavior.
Additional Information: For more information, see the Contact Management topic.
|Ruleset Windows for configured Actions||
Windows may be applied to configured actions that control the time frame of when that action can take place. When you assign a Window to a configured action you have the option to change the Window Behavior to one of the following:
Note: To apply a Window to a configured action, select the action in the Conditions pane, and then open the Ruleset tab for the selected action. Use the Window drop-down list to select your desired Window. Edit an existing window by selecting Edit, or create a new window by selecting New. Select Window Behavior, or use the Window Behavior drop-down list to choose the desired behavior.
Additional Information: For more information, see the Alerting and Responses System topic.
Expand the Schedules and Windows node in the Navigator pane to display the Schedules and Windows nodes. Create a new Schedule or Window by completing the following steps:
1. Double-click the Schedules or Windows node to open the Select a Schedule or Select a Window selection screen.
2. Select New to open the Schedule Properties or Window Properties window.
3. Enter a name for your Schedule or Window, then configure the properties. Select OK to save your schedule or window.
The following Schedule or Window Properties options are available:
|Name||The name that is applied to the Schedule or Window.|
|Specify the duration or length of time that the Window is active.
Note: Window Duration applies only to Windows and is not available for Schedules.
|One-time occurrence||Select the time you would like the one-time occurrence of the Schedule or Window to take place.
Note: This option is only applicable for schedule type: One Time.
|Frequency||The Frequency of the Schedule or Window can be set to either Daily, Weekly, or Monthly. Additional Frequency options are available depending on the chosen occurrence type.|
|DailyFrequency||Use the Daily Frequency options to select the specific time(s) during the day the Schedule or Window occurs.|
|Duration||Use the Duration section to specify a Start Date and End Date.|
|Summary||The Summary description auto-fills according to the chosen options. You may add to the summary or change the text as desired.|