Feature Request: enable/disable alert blackout via commandline

[tvanzeleDelen]

Hi,

Thanks for the alerting feature!

Would it be possible to enable/disable alert blackout periods via commandline, then we could integrate this in our pipelines for automated restores and patching.

Thanks

[DavidWiseman]

It seems like a good idea to include this as part of your automation. You could use dbatools to add and remove the blackout periods.

$ConnectionID ="INSTANCE_NAME_HERE"

$BlackoutPeriodID = New-DbaSqlParameter -ParameterName "BlackoutPeriodID" -SqlDbType Int -Direction Output
$params = @{
   BlackoutPeriodID = $BlackoutPeriodID
   StartDate = [DateTime]::UtcNow
   EndDate   = [DateTime]::UtcNow.AddHours(1) # 1hr duration
   ConnectionID=$ConnectionID
}
# Create blackout period
Invoke-DbaQuery -SqlInstance LOCALHOST -Database DBADashDB -Query "Alert.BlackoutPeriod_Add" -CommandType StoredProcedure -SqlParameters $params

# Do maintenance here
Start-Sleep -Seconds 30

# Remove blackout period

$BlackoutPeriodID = New-DbaSqlParameter -ParameterName "BlackoutPeriodID" -SqlDbType Int -Direction Input -Value $BlackoutPeriodID.Value

Invoke-DbaQuery -SqlInstance LOCALHOST -Database DBADashDB -Query "Alert.BlackoutPeriod_Del" -CommandType StoredProcedure -SqlParameters $BlackoutPeriodID

Hope this helps.