Each time this alert runs, it checks for any backup failures that have occurred since the previous execution. For example, with a 10-minute execution interval (default), only failures logged within the last 10 minutes will be captured. It uses the SYS.M_BACKUP_CATALOG system tables for the error source.
Use this screenshot as a template for the alert and the attached query for the SQL Statement: