We need guidance in fulfilling a request in TSQL. please help
we needed to trigger a mail, if we get the DB connections less than 20 in 3 continuous attempts in the period of 10 min each in a database.
we created a table where the information related to the DB Connections are loaded in to a table. now we are struck to write a condition for continuous 3 times every 10 min the same value less than 20 comes then trigger mail.
please suggest here to achieve the correct result.