Hello,
We have some complicated queries that are submitted to a database that is really, really big. The system will time out, just bringing back a message saying "Interrupted".
1. I know that you can provide a timeout parameter when using jobs:eval etc for batch jobs, but is there a setting that we can tweak to set the default for interactive (i.e. non jobs:eval) queries? 2. What is the default value for the timeout value? 3. How long will the server hang on to results from jobs:eval()? I think I remember reading that this is configurable, but how? Is it per job or globally for the server? 4. Can you consider adding an API that tells how long the job has been running?
Best Regards
Peter Villadsen Principal Architect Microsoft Business Applications Group