Fail-safe Operator – Powershell script

Powershell Script to find whether Fail-safe operator is enabled on sql server agent service. Fail-safe operator is recommended to be enabled,so, sql agent can communicate with the fail-safe operator,if it cannot notify the operator of the alert/job.


Add-pssnapin SQLServerCmdletsnapin100
Add-pssnapin SQLServerprovidersnapin100
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo.Extended")
$sqlserverList = ('SERVERNAME\INSTANCE1','SERVERNAME\INSTANCE2')
foreach($sqlserver in $sqlserverlist)
{
$s = New-Object Microsoft.SQLServer.Management.Smo.Server $SQLServer
$s.jobserver.alertsystem| select name,failsafeoperator,notificationmethod
}