Customizes the alert notification configuration for a specific monitored object and alert type.

Syntax

Update-SqlMonitorAlertNotificationSettings [-MonitoredObject] <MonitoredObject> [-AlertType] <int> [-Settings] <psobject> [<CommonParameters>]
 

Description

Customizes the alert notification configuration for a specific monitored object and alert type.

Parameters

-MonitoredObject <MonitoredObject>

The object to be configured (e.g. cluster, disk, database etc).

-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.

-Settings <PSObject>

The configuration to apply.

<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.

Return values

The output type is the type of the objects that the cmdlet emits.

• None.
  You cannot pipe input to this cmdlet.

Examples

-------------------------- EXAMPLE 1 --------------------------

$notificationsettings = @{
    EmailNotificationOption = [EmailNotificationOption]::SendToCustom
    EmailAddresses = 'foo.bar@companymail.com', 'monkey.banana@companymail.com'
    SlackEnabled = $true
SnmpEnabled = null # to leave a setting unchanged, simply leave as null
}
Update-SqlMonitorAlertNotificationSettings -MonitoredObject $database -AlertType $DatabaseAlertTypes.DatabaseFileUsage -Settings $notificationsettings