Disable master and msdb backups in SQL Server agent alarms (4210760)

When setting up SQL agents alerts are received regarding two tables not being backuped , in the alert origin the following rules appear: “DBSS days since last backup” and DBSS - Days Since Last Backup - No Backup

What is the best way to suppress the alerts for 'master' and 'msdb' databases?

RESOLUTION 1

1. Navigate to the Database Dashboard.
2. Check the SQL Server instance then click "Administer Agents".
3. Click either the "DBSS - Days Since Last Backup" and "DBSS - Days Since Last Backup - No Backup"alarm
4. Below Rule Exceptions, click the "Add Value" button
5. Select the databases to exclude or enter the database name
6. Click the Add button
7. Click the "Save Changes" button

RESOLUTION 2

(this will prevent monitoring of the database)

1. Navigate to the Database Dashboard.
2. Check the MSSQL instance then click "Administer Agents".
3. Click Databases Exclusion, then click the "Exclude Databases" button.
4. Use the dialog to add manually a MSSQL database, or select from the list of available, and move to the Excluded column.
5. Click the "OK" button.
6. Click the "Save changes" button, Agent properties are updated automatically.

RESOLUTION 3

Change the rule scope in both " DBSS - Days Since Last Backup"

and " DBSS - Days Since Last Backup - No Backup" rules:

DBSS_Database where (db_name != 'master') and (db_name != 'msdb')