Is it possible to add a filter to the "Job failing" alert?

lb483

We have a number of jobs which fail by design but are all named appropriately to indicate this. Is it possible to add a filter to the "Job failing" alert so that these get ignored? Alternatively, is there a way to retrieve the code used by the existing alert as the basis for a custom alert? Thanks.

Dan B

Hi lb483,

You should be able to configure these via the configuration>alert tab. On the left-hand panel, you can then select the instance which allows the job failing alert to be expanded showing all of the jobs which are running. Each of these can be configured to send emails or to be turned off.

Unfortunately, there is currently a bug open where you cannot multi-select jobs under the job failing header. Turning off the emails would need to be done for each job in turn.

Please do let me know if you require any further information on this.

lb483

Hi Dan.

Thanks for the feedback. Unfortunately the jobs are created dynamically to indicate a failure in another part of the system. Consequently the option to de-select them from alerting would only work after the failure has been raised as an alert.

Do you have the query details that the alert runs? I could then create a custom alert which excludes those matching this naming convention.

Many thanks.

Peter

lb483

Managed to implement a workaround. The list of alerts comes from the [alert].[Alert_Current] view so I added an additional WHERE clause to exclude the jobs I don't want to see and this solved my problem.

This is not recommended as it's changing the application's view but it works.

Dan B

Hi lb483,

Thanks for posting the workaround here.

I'm glad you managed to get this working .