cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 8

Populating sql job info in alert message

Hi,

We are monitoring SQL servers using appinsight.Its also monitoring SQL jobs.As part of alert we are only getting information info about job failure but there is no job name in the alert.Is there any variable through which we can populate failed job name in the alert? Please let us know if its possible.

0 Kudos
3 Replies
Highlighted
Level 15

Re: Populating sql job info in alert message

Did you try these variables?

neomatrix1217_0-1585345052491.png

 

Highlighted
Level 8

Re: Populating sql job info in alert message

Hi,

Thanks for the response.

Actually i am not able to see these variables when doing insert variables from alert.I will check this once more.One more thing, if i need sql job failure alerts for specific jobs on a particular SQL server then is there any way to do the filtering?

 

Thanks

Suman

0 Kudos
Highlighted
Level 15

Re: Populating sql job info in alert message

Notice the "I want to alert on" is set to and in the conditions, you can see that I am specifying a specific job.

 

neomatrix1217_0-1585436371473.png

 

0 Kudos