I have a build querying a DB, I initially connect to the DB, then use a DB Execute Query activity with this connection, this all works perfectly.
In the Virtual Machine I use, the retrieval of the info sometimes gets stalled; could be a number of factors (company use of the DB etc) however it doesn’t seem to timeout, and carries on (was running for just under an hour earlier).
Is there a way of setting a timeout for the result retrieval (I know the Timeout in properties is just for the execution itself). Ideally I would throw a Business Exception If > 15 mins or something.
Any help would be great,