View previous topic :: View next topic |
Author |
Message |
FLynch
Joined: 18 Jun 2002 Posts: 75 Location: London UK
|
Posted: Thu Aug 07, 2003 10:13 am Post subject: |
|
|
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 |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12801 Location: USA
|
Posted: Fri Aug 08, 2003 2:00 am Post subject: |
|
|
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 |
|
Back to top |
|
|
FLynch
Joined: 18 Jun 2002 Posts: 75 Location: London UK
|
Posted: Mon Aug 11, 2003 2:01 pm Post subject: Reply |
|
|
Thanks, I'll give option 1 a go!
Cheers
Fergus |
|
Back to top |
|
|
FLynch
Joined: 18 Jun 2002 Posts: 75 Location: London UK
|
Posted: Sat Nov 01, 2003 12:25 pm Post subject: |
|
|
Hi,
I've been sucessfully using expressions to compare the results of two tests and set off an alert if they are different.
Is it possible to use expressions to set the dependant test status to "Bad" using the same technique ?
Many Thanks
Fergus |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12801 Location: USA
|
Posted: Mon Nov 03, 2003 4:36 pm Post subject: |
|
|
Yes, you may use logical expression. If result of the expression is true, test will be performed. If result is False, OtherwiseStatus will be used.
If you want to use this method for your task with 2 ODBC test, you will need to create 3rd test.
Regards
Alex |
|
Back to top |
|
|
|