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.
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.
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)
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)