I have a process with an EXEC_SP which takes up to a minute to complete in the background. I would like to refresh a query when this process is done, and not just when it is started. The process is linked to another query on the same page (a VP that shows two queries, where the process is started from the first one, and the second one should be refreshed when the process is finished and the first query gets a value in a column).
Is there any way to achieve this except from auto refresh on the other query every 60 seconds? And if not, can I make the auto refresh to not be executed if the user has an open form? At this point the form will be closed if the user is doing an edit, or there will be a dialog box asking the user if the operation should be cancelled if the user is adding a new record, this I think is because this is done via a process.