Update Operator Email Address in Sql Server via Powershell

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();
		}
	}
}