time differnce between two databases (merged 3) [message #389506] |
Mon, 02 March 2009 06:38 |
tannad
Messages: 43 Registered: January 2008 Location: mumbai
|
Member |
|
|
I want to create a Script , which will check All the databases Date and time which are different host.
like
GLOBAL_NAME
------------------------------
P6NBSRTG
DATE_TIME
--------------------
01-MAR-2009 09:22:33
GLOBAL_NAME
------------------------------
P7NBSRTG
DATE_TIME
--------------------
01-MAR-2009 09:23:10
and if the time difference is greter than 1 minute it will give me alert on it
like
timediff is greter than 1 min in P6NBSRTG and P7NBSRTG
how can I create script for such databases?
|
|
|
|
|