[I've just added some caching to my Sql server](https://stackoverflow.com/questions/9264508/caching-joined-tables-in-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.