# Identifying when logstash jdbc SQL statement has completed execution
**URL:** https://discuss.elastic.co/t/identifying-when-logstash-jdbc-sql-statement-has-completed-execution/196574
**Category:** Logstash
**Created:** [August 23, 2019, 6:38pm UTC](https://discuss.elastic.co/t/identifying-when-logstash-jdbc-sql-statement-has-completed-execution/196574 "2019-08-23T18:38:50Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@stark525](https://discuss.elastic.co/u/stark525)
#### Post date: [August 23, 2019, 6:38pm UTC](https://discuss.elastic.co/t/identifying-when-logstash-jdbc-sql-statement-has-completed-execution/196574/1 "2019-08-23T18:38:51Z")
I've set up a logstash pipeline watching a directory for `logstash.conf` s with a jdbc input and elasticsearch output.
I enabled `.logstash_jdbc_test_last_run` , which logs the time when query is executed:
```auto
--- 2019-08-23 15:26:42.847349000 Z
```
When running logstash on the command line, my pipeline successfully processes a logstash conf file:
```auto
[2019-08-23T15:26:48,168][INFO][logstash.inputs.jdbc] (5.250782s) select S0.* from mytable S0
```
I'm trying to have my application notified that logstash has finished processing a logstash conf and the data is available in ES. Is there a way to write the timestamp when the query has completed to a file (for use as a flag in my application)?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 20, 2019, 6:38pm UTC](https://discuss.elastic.co/t/identifying-when-logstash-jdbc-sql-statement-has-completed-execution/196574/2 "2019-09-20T18:38:51Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.