Alert is not getting received when the job is failed. sql server probe no alarms at all.
In sqlserver probe version 5.42 has one new key added send_alarm for checkpoints and if it is enabled then an alarm will be send or else not.
In this version by default for all the checkpoints key is not enabled.
Have enabled the send_alarm flag for all the checkpoints in sqlserver version 5.42-HF3
To resolve this issue can follow the below steps:-
1 Delete the current sqlserver probe from IM (make sure all files deleted from disk also). Backup is not required as the customer is using the template created in version 5.41.
2 Deploy the sqlserver probe version 5.42-HF3.
3 Deploy the template created on version 5.41.
4 Now very the checkpoints send_alarm key it should be enabled.
5 For the next upgrade make new template with version 5.42-HF3, as this version as a lot of changes in .cfx file
If not possible to delete the probe then manually enable the send_alarm key for each checkpoint.