# Logstash - Keep it running

**URL:** https://discuss.elastic.co/t/logstash-keep-it-running/129427
**Category:** Logstash
**Created:** [April 25, 2018, 8:04am UTC](https://discuss.elastic.co/t/logstash-keep-it-running/129427 "2018-04-25T08:04:01Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Amol\_Hegana](https://avatars.discourse-cdn.com/v4/letter/a/977dab/32.png) [@Amol\_Hegana](https://discuss.elastic.co/u/Amol_Hegana)
#### Post date: [April 25, 2018, 8:04am UTC](https://discuss.elastic.co/t/logstash-keep-it-running/129427/1 "2018-04-25T08:04:01Z")

</div>

I have created environment where logstash is taking data from MS SQL server and feeding (output ) it to Elastic. Main reason to use logstash is to keep these both DB in sync. But now as soon as it feeds data into elastic, pipeline gets terminated.

[2018-04-25T13:13:14,338][INFO][logstash.pipeline] Pipeline has terminated {:pipeline\_id=\>"main", :thread=\>"#\<Thread:0x5d90da37 run\>"}

1. Do i need any config changes in order to keep logstash always running?
2. How does logstash detects changes in MS-SQL for updating it into Elastic?

---

<div class="post-metadata">

### Author: ![Jenni](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jenni/32/29684_2.png) [@Jenni](https://discuss.elastic.co/u/Jenni)
#### Post date: [April 25, 2018, 8:12am UTC](https://discuss.elastic.co/t/logstash-keep-it-running/129427/2 "2018-04-25T08:12:45Z")

</div>

You have to define a schedule to make LogStash query the database regularly and use the :sql\_last\_value to query only the new/changed entries, e.g.:

```
statement => "SELECT * FROM my_table WHERE modified >= :sql_last_value"
use_column_value => true
tracking_column => "modified"
tracking_column_type => "timestamp"

```

Have a look at the [JDBC input documentation](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html).

---

<div class="post-metadata">

### Author: ![Amol\_Hegana](https://avatars.discourse-cdn.com/v4/letter/a/977dab/32.png) [@Amol\_Hegana](https://discuss.elastic.co/u/Amol_Hegana)
#### Post date: [April 25, 2018, 1:33pm UTC](https://discuss.elastic.co/t/logstash-keep-it-running/129427/3 "2018-04-25T13:33:42Z")

</div>

Thanks [Jenni](https://discuss.elastic.co/u/Jenni)

---

<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: [May 23, 2018, 1:33pm UTC](https://discuss.elastic.co/t/logstash-keep-it-running/129427/4 "2018-05-23T13:33:43Z")

</div>

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