I'm using Logstash to fetch data from a database and index it into Elasticsearch. My Logstash configuration includes a schedule to run every 50 minutes like this:
input {
jdbc {
jdbc_connection_string => "jdbc:mysql://your-database-url"
jdbc_user => "your-user"
jdbc_password => "your-password"
schedule => "*/50 * * * *"
statement => "SELECT * FROM your_table"
}
}
output {
elasticsearch {
hosts => ["http://localhost:9200"]
index => "my-index"
}
}
What I Want to Achieve
- Delete the Elasticsearch index at 10:00 AM every day.
- Run Logstash immediately after the deletion.
- Ensure Logstash continues running on the 50-minute schedule.