WORKAROUND:
1) Create PowerShell script. It is necessary to manage parameters sent to the script.
Save this script somewhere to disk, where it can be accessible. Here is an example of the script.
--------------------------------------------------------------------------------------------
$alarm_name = $args[0]
$conn_name = $args[1]
$smtp = "10.1.0.160"
$from = "test@quest.com"
$to = "test@quest.com"
$subject = $alarm_name
$prio = “High”
$body = "Notification received
Blocked session:"
$body += $conn_name
Send-MailMessage -From $from -To $to -SmtpServer $smtp -Subject $subject -Body $body -Priority $prio
----------------------------------------------------------
2) In alarm action use "Run a program" and type there calling of PowerShell command where the parameter in double quotes is script name and arguments. Example:
powershell "C:\psemail.ps1 '{{ALARM_NAME}}' '{{CONNECTION_NAME}}'"
You need to replace the location of the PowerShell file and also need to align the order of parameters in command with variables used in the script.
STATUS
The enhancement request SOSSE-6219 has been submitted to Development for consideration in a future release of Spotlight on SQL Server Enterprise.
