When will SQL query be executed?

I want to get the latest entries from database (SQL) of the day, and want that query should be fired only once in a day at 5min before the end of the day (say at 23:55),

So if I write such sql query which has an interval of 1d to be evaluated, at what time it gets executed.

1 Like

Hi zealousmacwan,
Grafana haven’t this feature, the queries are triggered by various reasons, for example load dashboard… You will have more that one execution per day.

1 Like

Maybe you should consider creating a script (in any language) and run it in a cron tab.
This script could create a SQL VIEW and Grafana will query that view.
(just an idea)

1 Like

Only and easiest way I see is to create a .bat file and schedule it through “windows task scheduler” @23:55 to run a .sh file that has your SQL Query ( select * from x.x order by date desc limit 1)

1 Like