Hey Guys,
My problem:
I have a script that will be querying the database every minute to see if it gets a response, the response its querying for is "UP" in a table i made called dbup in the database.
Now, I am trying to add the component to implement a timeout if the script does not get a response from the server and skip to next line etc.
I would like to implement it either at the DB layer because of issues we have had with the product.
We want to skip the -->
I assign the variable query_select1, before I query DB to assign it to STRING "UP.
query_select1="down"
-->query_select1= ##QUERY SELECT FROM DB String "UP"##
Any help would be appreciated. NOTE: we would like to avoid killing the script, but if necessary I might be ok with killing it and then sending message to myself that process got killed this is why.
But I really could use a solution to this because When the variable ="down" stays the same and doesn't get changed to "UP" from Database, then it gets passed onto the auto generated emails we have setup.
If there are other methods that I haven't thought of let me know as well.
RHEL6