any support, idea to generate an audible alarm will be appreciated. thanks.
You would need to have some VBA code to play a sound when a certain state is true. Here are some links to past questions/articles on this:
You didn't specify what application you were using; I'm assuming ProcessBook. This isn't possible in Vision without a lot more effort and custom modifications.
Retrieving data ...