I'm using the Jdbc input to retrieve data from MS SQL database once a minute.
Usually it works fine. But as we know database performance is not very reliable thing and sometime it's take longer than one minute to the query to return. Sometime event 5 minutes.
But the Jdbc scheduler still run a query once a minute so there situations when multiple queries run at the same time. This creates additional pressure on a database and after some time there are 20 almost same queries run at the same time.
I assume I'm not the first person which encounter this problem. I'm sure there is some way to make Jdbc to run query a minute after the previous once is finished. Am I right?