Setting up Data Level Application Alerts in SQL Server
No, there is not any built-in feature that does exactly this.  I'm also not aware of an off-the-shelf product that does what you're looking for.

However, based on the description of your requirements, it seems like a SQL Server Agent job would work really well!

Set up an agent job that runs every 15 minutes, has steps that run the different checks you're interested in, and sends emails to your support team using sp_send_dbmail.

To get started, find the "SQL Server Agent" node in SSMS, right click on "Jobs," and choose "New Job."  There's a detailed walkthrough of all the options here: Create a Job | Microsoft Docs