# How JDBC input get data without schedule?

**URL:** <https://discuss.elastic.co/t/how-jdbc-input-get-data-without-schedule/233790>\
**Category:** Logstash\
**Created:** [May 21, 2020, 6:23pm UTC](https://discuss.elastic.co/t/how-jdbc-input-get-data-without-schedule/233790 "2020-05-21T18:23:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ElasticLiver](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/elasticliver/32/64869_2.png) [@ElasticLiver](https://discuss.elastic.co/u/ElasticLiver)\
**Post date:** [May 21, 2020, 6:23pm UTC](https://discuss.elastic.co/t/how-jdbc-input-get-data-without-schedule/233790/1 "2020-05-21T18:23:03Z")

</div>

A coworker told me that you can ommit the schedule in the JDBC input, and still will get data, if this is true, how and when the SQL query get triggered? does logtash check for changes in the DB periodically?

---

<div class="post-metadata">

**Author:** ![ptamba](https://avatars.discourse-cdn.com/v4/letter/p/7feea3/32.png) [@ptamba](https://discuss.elastic.co/u/ptamba)\
**Post date:** [May 22, 2020, 12:29pm UTC](https://discuss.elastic.co/t/how-jdbc-input-get-data-without-schedule/233790/2 "2020-05-22T12:29:23Z")

</div>

don’t think that’s possible. jdbc input uses scheduler

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [May 22, 2020, 2:12pm UTC](https://discuss.elastic.co/t/how-jdbc-input-get-data-without-schedule/233790/3 "2020-05-22T14:12:17Z")

</div>

The schedule option is optional. If it is not supplied then the query will be run exactly once at startup.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 19, 2020, 2:23pm UTC](https://discuss.elastic.co/t/how-jdbc-input-get-data-without-schedule/233790/4 "2020-06-19T14:23:52Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
