Hi,
I have 2 ODBC tests which query a replicated database held on two physically seperate servers. The ODBC query is a simple "SELECT COUNT" to check the same number of rows are on each database (and hence the replication is working)
Is it possible to set up an alert if the values on the tests start to differ?
Thanks
Fergus
Alerts: Comparing the results of two tests
I see 2 solutions:
1) create 2 tests, setup one test as Master for another (to synchronize time execution), assign "advanced" action to the dependant test. use logical expression to start action, something like "('%::TestA::Status%'=='%::TestB::Status%') and ('%::TestA::Reply%'<>'%::TestB::Reply%')"
2) use some stored procedure to calculate difference between databases, and setup single ODBC test to retrieve that value
Regards
Alex
1) create 2 tests, setup one test as Master for another (to synchronize time execution), assign "advanced" action to the dependant test. use logical expression to start action, something like "('%::TestA::Status%'=='%::TestB::Status%') and ('%::TestA::Reply%'<>'%::TestB::Reply%')"
2) use some stored procedure to calculate difference between databases, and setup single ODBC test to retrieve that value
Regards
Alex