Quick script to update all the operators’ email addresses in sql server via powershell when passing in the old email address. This uses SQLPSX.
param(
[String[]]$serverInstance = @('Server1', 'Server2', 'Server3'),
[string]$oldEmailAddress = 'oldemail@yourdomain.com',
[string]$newEmailAddress = 'newemail@yourdomain.com'
)
Import-Module Agent
$serverInstance | %{
Get-AgentJobServer -sqlserver $_ | %{
Get-AgentOperator -jobserver $_ | where{$_.EmailAddress -eq $oldEmailAddress}| %{
$_.EmailAddress = $newEmailAddress;
$_.Alter();
}
}
}
Sql Server Powershell 
Leave a comment