# Logstash JDBC plugin question
**URL:** https://discuss.elastic.co/t/logstash-jdbc-plugin-question/41586
**Category:** Logstash
**Created:** [February 12, 2016, 9:19am UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-question/41586 "2016-02-12T09:19:23Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@jaminvp](https://discuss.elastic.co/u/jaminvp)
#### Post date: [February 12, 2016, 9:19am UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-question/41586/1 "2016-02-12T09:19:23Z")
Greetings,
Presume I have a database table containing status info about processing jobs.
This table would have the following columns with an example rule:
JobID - Jobname - RunDate - Status - StartTimestamp - EndTimestamp - Other informative columns
* * *
1 - job - 10/02/2016 - WAITING - 10:00 - 10:05 - ...
Now presume I have the logstash JDBC plugin running a query periodically to select all jobs with their statusinfo. How would an update of the job status of this row (WAITING --\> SUCCEEDED) in the database table affect Elasticsearch? Would a log with a different statusupdate be inserted into Elasticsearch or would the existing log be updated?
---
### Author:  [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [February 14, 2016, 12:01pm UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-question/41586/2 "2016-02-14T12:01:34Z")
Whichever you prefer. By default each event passing through Logstash will result in a new document in ES, but you can override that behavior by setting the elasticsearch output's [`document_id` option](https://www.elastic.co/guide/en/logstash/current/plugins-outputs-elasticsearch.html#plugins-outputs-elasticsearch-document_id) to choose the id of the document to index or update. For example, if the database table's JobID column is a suitable primary key in the ES index you should be able to do this to keep the job's information updated:
```ruby
elasticsearch {
...
document_id => "%{JobID}"
}
```
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 5:11am UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-question/41586/3 "2017-07-06T05:11:38Z")