Update Operator Email Address in Sql Server via Powershell

Scott Newman Powershell, SQL Server March 5, 2013March 5, 2013 1 Minute

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