I get data from a DB every 30 minutes, in the image the current time is 18:50 pm, I should have no data from 18:30 to current time because this data is collected at 19:00 pm
It seems that some documents are misconfigured in the DB with a timestamp ahead of time, this also set my sql_last_value ahead of time and when JDBC is collecting data I only get half of it.
To solve this I was thinking in get the current time with ruby and compare it with the timestamp, if timestamp its greater than the current time, drop the event.
if I drop the event the sql_last_value is still recorded in the last run file?
Is there another way, that you may think, to solve this?