Hi,
I'm working on a solution where if there is a data feed break - Then it needs to be notified. We get data for every 10 minutes. If a particular site is not sending data after 11th minute then we should get notified. There can be 1000s of sites sending data.
We are using SQL Server 2012. is there an advanced mechanism in 2012 which can do this for me, instead of querying the table in usual methods.
Thanks,
Ami