I've just added some caching to my Sql server to speed up a particularly important
SELECT query. This cache will be refreshed every ~10 minutes. The time between activations does not have to be predictable, so long as there is not a long delay between activations.
Is using the Sql server agent the right solution here? This seems to be more aimed at large database maintenance tasks. Should I use a different SQL Server method, or perhaps trigger the update from my client application?
Also, my dev machine does not have the server agent available, so using a different method is attractive for that reason.