Forum Discussion

Jeremy_Wanamake's avatar
Jeremy_Wanamake
9 years ago

Custom datasource collection interval and on-demand collection

We use JDBC to run queries against SQL Server and MySQL databases. Some of the queries we'd like to run are resource intensive and cannot be run during business hours. We'd like to be able to set a...
datasource
Dave_Lee_Q's avatar
Dave_Lee_Q
9 years ago

Jeremy,

One way to do this is to write a powershell script that checks the time now, and if its between 1 a.m. and 2 .a.m runs the query, if not does nothing but report the values returned from the last time it ran. 

Incorporate this into a datasource and its only going to run the query at that time. You set the ds to run every hour, but it wont run the query until the right time.

David