Did not receive SQL Agent Job failure alert

book

Article ID: 196438

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction


 Alert is not getting received when the job is failed. sql server probe no alarms at all.




 

Environment

UIM 8.51

SQLSERVER 5.42

Resolution

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.