Hi,

I need to monitor 2 coulmn values of my databse with some condition every minute. If the condition is failed I need to store the record in another databse table with  extra column 'status' with the value 'Fail'.

If the columnvalues of the main database fulfils the condition need to record the seond databse table as 'Cleared'.

can I use application variables to keep track of the status. or is there any better alternative?

What happens if the server restarts. Values will be reset. Anyway the previous values I am going to store in the database. Now using the application variable in the development machine. What happens after we deploy in the production server. The variables are reset or still maintained.

Thanks.

Then the alternative option is checking the 'status' value from the second database. I need to check against 8 tables for this 'status' value and having trouble in implemeting. That is the reason I chose application variables.

Please somebody help me to find feasible solution to handle this situation.

Thank you.