Delay continuous queries execution

Hi!
At my organization we are writing points with timestamps into influxDb.
That means a point with a timestamp hour of 9:59 AM, may be written past 10 AM.
A continuous query that runs hourly will miss this point during its execution.

What I’d like to know is whether I can configure the continuous query to run every hour plus 5 minutes, for example. (09:05, 10:05, 11:05… etc.)

Our hourly CQs, usually go something like this:
CREATE CONTINUOUS QUERY CQ1 ON myDB
BEGIN SELECT sum(Total) AS Total
INTO myDB.Hourly.task_progress
FROM myDB.Raw.task_progress
GROUP BY time(1h), task_name, task_id fill(none)
END

1 Like