question

sand143eep avatar image
sand143eep asked

Needed help in getting the condition

Hi Team,

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.

sqlserver2012sql2008sqlserver2014
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.