1 2 Previous Next 15 Replies Latest reply: Aug 30, 2013 4:05 AM by Christian RSS

    Create Compare Script

    Christian

      Hey, I am not really good in scripting, perhaps you guys can help real quick.

       

      I like to compare  numbers in a table in two databases ( mirrored by GoldenGate).

      If the source number of this column is higher (+5) than the destination database I like to send a snmp trap to my monitoring.

       

      How would you do this ? Creating a public database link on the source site, a query the same table and compare the values ?

       

      select id from table_a;  eg (result 99)

      select id from table_a@publink; eg  (result 98)

       

      How to compare ?

       

      Chris

        1 2 Previous Next