I am new to SQL and use Azure Data Studio for data analysis. I am trying to setup a conditional email/text alert when a column value is greater than a given value in my SQL database. I am confused how to go about this... would I use SMTP, Azure monitor, etc.?
I have looked into Azure monitor, but it seems that it is more commonly used for alerts regarding the performance of a database and not the values contained within the database.