Skip to content

Instantly share code, notes, and snippets.

@ghotz
Last active October 15, 2022 21:52
Show Gist options
  • Save ghotz/f0f862e2d93a7b1d05bdc110a8a2a552 to your computer and use it in GitHub Desktop.
Save ghotz/f0f862e2d93a7b1d05bdc110a8a2a552 to your computer and use it in GitHub Desktop.
Change SQL Server Agent Alert Delay Between Responses from 0 to 60
$cred = Get-Credential;
Get-DbaRegisteredServer -Group "Monitored\SQLAuth" | % {
Write-Host "connecting to $($_.ServerName)";
$srv = new-object Microsoft.sqlserver.management.smo.server $_.ServerName;
$srv.ConnectionContext.LoginSecure = $false;
$srv.ConnectionContext.Login = $Cred.UserName;
$srv.ConnectionContext.set_SecurePassword($cred.Password);
$srv.JobServer.Alerts | % {
if ($_.DelayBetweenResponses -eq 0) { $_.DelayBetweenResponses = 60; $_.Alter(); }
}
}
}
Get-DbaRegisteredServer -Group "Monitored\WindowsAuth" | % {
Write-Host "connecting to $($_.ServerName)";
$srv = new-object Microsoft.sqlserver.management.smo.server $_.ServerName
; $srv.JobServer.Alerts | % {
if ($_.DelayBetweenResponses -eq 0) { $_.DelayBetweenResponses = 60; $_.Alter(); }
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment