This table gives you control over various alert options. These options are merely cosmetic in the alerts themselves.
| Name | Data type | Nullable | Description |
|---|---|---|---|
| ID | int IDENTITY(1,1) | NOT NULL | |
| ReportName | varchar(50) | NULL | Default value is MinionDefault and using it lets all reports without overrides use this setting. To give a specific report different settings create a new row and supply the report name. |
| ServiceLevel | varchar(10) | NULL | Default value is All and is used in conjunction with MinionDefault above. Otherwise, supply an SLA from the dbo.Servers table. |
| ShowDefer | bit | NULL | Whether to show the defer statements in the alert. See below for more details. |
| ShowChange | bit | NULL | Whether to show the change statements in the alert. See below for more details. |
| ShowException | bit | NULL | Whether to show the exception statements in the alert. See below for more details. |
| ShowDeferTable | bit | NULL | Whether to show the defer table in the alert. See below for more details. |
| DeferHrs | int | NULL | The number of hours to use in the defer statement by default. See below for more details. |
| UseNightMode | bit | NULL | Whether to use Night Mode for the alerts. See below for more details. |
| AutoCodeThreshold | int | NULL | The threshold to use for switching to the Master statements instead of individuals. See below for more details. |
| IsActive | bit | NULL | Activates or deactivates the row. This lets you toggle settings without losing your data. |
| Comment | varchar(1000) | NULL | Put any comments here. This can be used in conjunction with IsActive so you can more easily toggle active rows. Use the value in this column to identify the rows you want to toggle. For example, WHERE Comment = 'Weekend setting'. |
ShowDefer
Every alert can be deferred. And inside each alert we give you the statements needed to defer each alert row to make it easier to manage. This setting controls whether or not to show these statements.
ShowChange
Alert thresholds may need to be changed if you're getting alerts too often, or if a situation changes. We provide the statements to change the thresholds in each alert. This setting controls whether or not to show these statements.
ShowException
You may want to turn off reporting for a an alert on a single box or several. In all alerts, we provide the statements to create report exceptions. This setting controls whether or not to show these statements.
ShowDeferTable
Since all alerts can be deferred, it's nice to have the option to see which ones deferments are currently active. So say you deferred a server's Diff backups. You don't have to bother to tell the rest of your team cause you can display the defer table in the alert so they can see it themselves. This setting controls whether or not to show this table.
DeferHrs
Alerts get deferred for a given number of hours. And the statements need to define the number of hours you want to defer them for. This defines the number of hours you want to show up in the alert statement. For example, you may want to defer backups for a different amount of time than disk space issues. The value can be changed once you copy the statement out of the alert and into SSMS, but this just makes it easier to not have to do that.
UseNightMode
We at MinionWare like to think we have considered, thoughtful features. This is one of our favorites. This toggles Night Mode on and off. You can read more about Night Mode here.
AutoCodeThreshold
You can easily run into a situation where the alert email gets overwhelmed with defer statements. For example, a NAS has an issue one night and and 400 DBs don't get backed up. Now you have an alert email with 400 DBs, and 400 defer statements, 400 change statements, and 400 exception statements. This will be very laborious to look through. In this case you'll want to set this option. This option lets you define the number of alert rows where it switches from using individual row statements to using a grouped master SP. Now you have 400 an alert with 400 DBs, 1 defer statement, 1 change statement, and 1 exception statement.