(Copying information from my Community post)
We've configured Prognosis to output through ODBC into SQL Server for our Base24-eps data.
Recently our DBA pointed out that this query is performed every 2-3 minutes all day and it's a pretty high impact on the server.
Can you tell me why this query is running every 2-3 minutes and is there a way to supress it?
Not sure of the details of the process. It sounds like you are summarizing from a prognosis database to the MS SQL database. If so the frequency can be controlled by the database summary properties on the configuration tab. let me know if this help or if there is something different set up.