DB Stream Monitors

Discussion created by 1_akannan on Sep 26, 2014
Latest reply on Sep 26, 2014 by jonhcw



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


TIME                                GNAME                                             
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.