# How can i schedule logstash every second for jdbc input plugin?
**URL:** https://discuss.elastic.co/t/how-can-i-schedule-logstash-every-second-for-jdbc-input-plugin/27393
**Category:** Logstash
**Created:** [August 14, 2015, 12:16pm UTC](https://discuss.elastic.co/t/how-can-i-schedule-logstash-every-second-for-jdbc-input-plugin/27393 "2015-08-14T12:16:47Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@rkhapre](https://discuss.elastic.co/u/rkhapre)
#### Post date: [August 14, 2015, 12:16pm UTC](https://discuss.elastic.co/t/how-can-i-schedule-logstash-every-second-for-jdbc-input-plugin/27393/1 "2015-08-14T12:16:47Z")
Hi All
I am using this configuration for jdbc input plugin
schedule =\> "\* \* \* \* \*"
How I can schedule logstash for every 1 second or 2 second?
Regards
Ritesh
---
### Author:  [@rkhapre](https://discuss.elastic.co/u/rkhapre)
#### Post date: [August 17, 2015, 12:31pm UTC](https://discuss.elastic.co/t/how-can-i-schedule-logstash-every-second-for-jdbc-input-plugin/27393/2 "2015-08-17T12:31:41Z")
Has no one used jdbc logstash plugin?
---
### Author:  [@michaellizhou](https://discuss.elastic.co/u/michaellizhou)
#### Post date: [September 4, 2015, 2:02pm UTC](https://discuss.elastic.co/t/how-can-i-schedule-logstash-every-second-for-jdbc-input-plugin/27393/3 "2015-09-04T14:02:18Z")
Ritesh,
The current schedule config that you have is for every second. For every 2 seconds I believe you just use '2 \* \* \* \* '
rufus-scheduler is a good guide to get the correct time take a look on git
---
### Author:  [@Pragmateek](https://discuss.elastic.co/u/Pragmateek)
#### Post date: [April 4, 2016, 5:57pm UTC](https://discuss.elastic.co/t/how-can-i-schedule-logstash-every-second-for-jdbc-input-plugin/27393/4 "2016-04-04T17:57:35Z")
The Cron format has been extended to support seconds :
"\* \* \* \* _" means every minute
"_ \* \* \* \* _" means every second
"_/2 \* \* \* \* \*" means every 2 seconds
Hope this helps...
---
### Author:  [@sombilat](https://discuss.elastic.co/u/sombilat)
#### Post date: [May 30, 2016, 2:28pm UTC](https://discuss.elastic.co/t/how-can-i-schedule-logstash-every-second-for-jdbc-input-plugin/27393/5 "2016-05-30T14:28:52Z")
Hi Guys,
How do I get it for every 24 hours?
I tried both lines below:
-
-
- \*/24
\*/24 \* \* \*
But none worked, it said it was a bad cronline in the output.
Thanks,
---
### Author:  [@alaviamir](https://discuss.elastic.co/u/alaviamir)
#### Post date: [June 6, 2016, 2:48pm UTC](https://discuss.elastic.co/t/how-can-i-schedule-logstash-every-second-for-jdbc-input-plugin/27393/6 "2016-06-06T14:48:13Z")
"30 4 \* \* \*"
Run every day at 4:30AM
"0 0 \* \* \*"
Run every day at 12:00AM
"59 23 \* \* \*"
Run every day at 11:59PM
"0 12 \* \* \*"
Run every day at 12:00PM
---
### Author:  [@xiaozhuqq48](https://discuss.elastic.co/u/xiaozhuqq48)
#### Post date: [October 4, 2016, 1:20pm UTC](https://discuss.elastic.co/t/how-can-i-schedule-logstash-every-second-for-jdbc-input-plugin/27393/7 "2016-10-04T13:20:58Z")
Hi, rkhapre:
Did you solve this problem? How?
I have the same issue now. I have to narrow down the period to every 5 seconds.
Hope to hear from you, thanks.
---
### Author:  [@rkhapre](https://discuss.elastic.co/u/rkhapre)
#### Post date: [October 5, 2016, 9:27pm UTC](https://discuss.elastic.co/t/how-can-i-schedule-logstash-every-second-for-jdbc-input-plugin/27393/8 "2016-10-05T21:27:27Z")
Hi
5 star means every 1 second
`schedule => "* * * * *"`
for every 5 second use this
`schedule => "5 * * * *"`
---
### Author:  [@xiaozhuqq48](https://discuss.elastic.co/u/xiaozhuqq48)
#### Post date: [October 6, 2016, 8:37am UTC](https://discuss.elastic.co/t/how-can-i-schedule-logstash-every-second-for-jdbc-input-plugin/27393/9 "2016-10-06T08:37:15Z")
Thanks. I found out in the code, \*/5 \* \* \* \* \* means every 5 seconds.
And what version of Logstash are you using?
PS: it 'handles crontab steps syntax in six-field forms' do
expect(Rufus::Scheduler::CronLine.new(
'\*/10 \* \* \* \* _').frequency).to eq(10)
expect(Rufus::Scheduler::CronLine.new(
'_ \*/10 \* \* \* _').frequency).to eq(1) # "_" all seconds [0..59]
expect(Rufus::Scheduler::CronLine.new(
'0 \*/10 \* \* \* \*').frequency).to eq(10 \* 60)
end
```
end
```
---
### Author:  [@Thangaraj\_Muruganant](https://discuss.elastic.co/u/Thangaraj_Muruganant)
#### Post date: [March 15, 2017, 8:18am UTC](https://discuss.elastic.co/t/how-can-i-schedule-logstash-every-second-for-jdbc-input-plugin/27393/10 "2017-03-15T08:18:59Z")
schedule =\> "\*/5 \* \* \* \* \* " for every 5 seconds
schedule =\> "\* \* \* \* \* \* " Loads every second
hope you got the difference..
---
### Author:  [@theuntergeek](https://discuss.elastic.co/u/theuntergeek)
#### Post date: [March 15, 2017, 2:26pm UTC](https://discuss.elastic.co/t/how-can-i-schedule-logstash-every-second-for-jdbc-input-plugin/27393/11 "2017-03-15T14:26:33Z")
You can't just add another star and take minute resolution down to seconds. Not with cron syntax.
This plugin uses the rufus-scheduler module in cron mode. You can schedule down to the minute (5 fields) just like cron, but not seconds.
Want a query to run every second? Currently this plugin does not allow for that.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 4:27am UTC](https://discuss.elastic.co/t/how-can-i-schedule-logstash-every-second-for-jdbc-input-plugin/27393/12 "2017-07-06T04:27:48Z")