Need little help in configuring few database monitors. We have two db streams that run on a defined time period. Our client wants us to alert if the time difference between these two streams is more than 20 mins, they need to be informed of that. this is the command that we execute
select * from ws_app_owner.HEARTBEAT_STR;
The output is as follows
9/16/2014 9:06:32.000000 AM server1.WORLD
9/16/2014 9:06:18.000000 AM server2.WORLD
We need to be alerted if the time difference between server1.world and server2.world is more than 20 mins. This is a sql server and can this be accomplished through sql probe or logmon. If it is a no for both of these probes, then please suggest me on how to achieve this.