functions/SetJobNotification.ps1
|
Function Set-JobNotification { <# .Synopsis Set the notification setting of the SQL Agent Job to The Operator. .Description If the SQL Agent Job has an Operator associated to it then we set the notifications (if any) to point to the Operator. .Parameter JobToAlter Job whose properties we will be altering. .Example $JobOperatorName = $root.Operator.Name if ($JobOperatorName.Length -gt 0) { Write-Verbose "Operator assigned to job. Altering notification settings based on XML..." Set-JobNotification -JobToAlter $JobToAlter -root $root } else { Write-Verbose "No Operator Information to set." } #> [CmdletBinding()] param ( [System.Xml.XmlLinkedNode] [ValidateNotNullorEmpty()] $root, [Microsoft.SqlServer.Management.Smo.Agent.Job] [ValidateNotNullorEmpty()] $JobToAlter ) $JobEmailLevel = $root.Notification.SendEmail $JobPagerLevel = $root.Notification.SendPage $JobNetSendLevel = $root.Notification.SendNetSend $JobEventLogLevel = $root.Notification.SendEventLog $JobToAlter.EmailLevel = $JobEmailLevel if ($JobEmailLevel -ne "Never") { Write-Verbose "Setting job to email $JobOperatorName on action $JobEmailLevel" $JobToAlter.OperatorToEmail = $JobOperatorName } $JobToAlter.PageLevel = $jobPagerLevel if ($JobPagerLevel -ne "Never") { Write-Verbose "Setting job to page $JobOperatorName on action $jobPagerLevel" $JobToAlter.OperatorToPage = $JobOperatorName } $JobToAlter.NetSendLevel = $JobNetSendLevel if ($JobNetSendLevel -ne "Never") { Write-Verbose "Setting job to netsend $JobOperatorName on action $JobNetSendLevel" $JobToAlter.OperatorToNetSend = $JobOperatorName } $JobToAlter.EventLogLevel = $JobEventLogLevel if ($JobEventLogLevel -ne "Never") { Write-Verbose "Setting job to write to Windows Application event log on action $JobEventLogLevel" } try { $JobToAlter.Alter() $JobToAlter.Refresh() } catch { Write-Error "Something has gone wrong in setting job notifications on $($jobToAlter.Name)" Throw $_.Exception Throw } } |