This page covers common questions about using Alert Rules to suppress the SQL Server Agent Job Failed alert for specific jobs.
Can I suppress the SQL Server Agent Job Failed alert for specific jobs without affecting other alerts or instances?
Yes. Use an Alert Rule with the Ignore Alert behavior to suppress the alert for specific jobs. This gives you precise control without changing the alert itself or impacting other clients or configurations.
To set this up:
- Go to Admin Console › Alert Rules and create a new rule
- Set the Alert Type to SQL Server Agent Job Failed
- Set the Scope
- Choose between selecting Profiles or Resources
- You may select one or many under either option
- Choose between selecting Profiles or Resources
- Once a scope is selected, an Objects field set to Job will appear. Use the Search Jobs field to find and select the jobs that should be suppressed. The available jobs list is based on the instances in your selected scope.
- Enable the Ignore Alert toggle under Enter Rule Behavior
Tip: Select All current and future objects to automatically apply the rule to any job — including newly created jobs — within the selected scope.
I have many jobs that follow a naming convention. Do I have to add them one by one?
No. The Objects field supports wildcard patterns alongside individual job name selections — and you can combine both in the same rule.
To add a wildcard, type a pattern into the search field using the percent sign (%) as a wildcard character, then click Add Object. For example:
%Backup%— matches any job containing "Backup"Maintenance%— matches any job starting with "Maintenance"%Cleanup— matches any job ending with "Cleanup"
You can add multiple wildcard patterns and specific job selections to the same rule. The badge on the Job dropdown reflects the total number of objects currently added. All wildcard patterns apply across every instance in the selected scope.
How do I decide whether to scope the rule to a Profile or to Resources?
| Recommended Scope | Scenario |
|---|---|
| Profile | You Jons on any new instance added to WISdom to be bound by the Alert Rule without having to modify the rule by adding the Resource |
| Resources | Jobs have unique names on specific instances only |
| A mix of both | Create separate rules — a wildcard rule scoped to a Profile, and individual selections scoped to specific Resources |