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”.
- 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?
- What is the default value for the timeout value?
- 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?
- 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