# Only one batch query executed

**URL:** <https://forum.confluent.io/t/only-one-batch-query-executed/7567>\
**Category:** Kafka Connect\
**Created:** [5 April 2023 08:49 UTC](https://forum.confluent.io/t/only-one-batch-query-executed/7567 "2023-04-05T08:49:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![JulianG](https://avatars.discourse-cdn.com/v4/letter/j/90db22/32.png) [@JulianG](https://forum.confluent.io/u/JulianG)\
**Post date:** [5 April 2023 08:49 UTC](https://forum.confluent.io/t/only-one-batch-query-executed/7567/1 "2023-04-05T08:49:08Z")

</div>

Hello everybody,

I have a problem with my JDBC Source connector.  
I want to sync a MSSQL table with over 60 Mio. rows in bulk mode.  
I want the connector to perform this sync once a week so I set “poll.interval.ms”: 604800000.  
Additionaly I set “batch.max.rows”: 100000.

When I start the connector I only get 100k rows and nothing more.  
Am I missing something??? I thought the connector would execute batch queries with 100k rows till it reaches the 60 Mio.

Please can somebody help me it is really important

Thanks and best regards

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/1X/c49438c90c9df282e9996fdf6971be890c71b65a.svg) [@system](https://forum.confluent.io/u/system)\
**Post date:** [5 May 2023 08:49 UTC](https://forum.confluent.io/t/only-one-batch-query-executed/7567/2 "2023-05-05T08:49:23Z")

</div>

Closed on 5 May 2023 08:49 UTC

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