These pages cover SQL Monitor 13, which is not the latest version. Help for other versions is also available.
Update-SqlMonitorAlertSpecificSettings
Published 14 February 2023
Updates the alert settings for a specific alert type and target monitored object.
Syntax
- Update-SqlMonitorAlertSpecificSettings [-MonitoredObject] <TraversableObject> [-AlertType] <int> [-Settings] <SpecificAlertSettings> [<CommonParameters>]
Description
Updates the alert settings for a specific alert type and monitored object. The alert settings object will depend on the alert type.
Parameters
-MonitoredObject
<TraversableObject>
The object to be configured (e.g. cluster, disk, database etc)
| Aliases | None |
| Required? | true |
| Position? | 1 |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-AlertType
<Int32>
The id of the alert type. Predefined ids are accessible through global alert type variables, $AlertType, $AgAlertTypes, $AzureSqlDatabaseAlertTypes, $AzureSqlServerAlertTypes, $ClusterAlertTypes, $ClusterMachineAlertTypes, $DatabaseAlertTypes, $DiskAlertTypes, $ElasticPoolAlertTypes, $InstanceAlertTypes, $JobAlertTypes and $StandaloneMachineAlertTypes.
| Aliases | None |
| Required? | true |
| Position? | 2 |
| Default Value | 0 |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-Settings
<SpecificAlertSettings>
The configuration to apply
| Aliases | None |
| Required? | true |
| Position? | 3 |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-ProgressAction
<ActionPreference>
{{ Fill ProgressAction Description }}
| Aliases | None |
| Required? | false |
| Position? | named |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
<CommonParameters>
This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see http://technet.microsoft.com/en-us/library/hh847884.aspx.
Inputs
The input type is the type of the objects that you can pipe to the cmdlet.
-
None.
You cannot pipe input to this cmdlet.
Examples
-------------------------- EXAMPLE 1 --------------------------
- $alertSettings = New-SqlMonitorAlertSpecificSettings -AlertType $DatabaseAlertTypes.DatabaseFileUsage
- $alertSettings.Mode = 'PercentFull'
- $alertSettings.HighEnabled = $true
- $alertSettings.HighThreshold = 87 # Since 'Mode' is 'PercentFull' this value will be considered 87%
- Update-SqlMonitorAlertSpecificSettings -MonitoredObject $database -AlertType $DatabaseAlertTypes.DatabaseFileUsage -Settings $alertSettings
