# CDC/CT - Resynchronize from Date **URL:** \ **Category:** Ideas\ **Tags:** idea, cdata-sync, sql-server, cdc, change-tracking\ **Created:** [December 23, 2023, 3:23pm UTC](https://community.cdata.com/t/cdc-ct-resynchronize-from-date/583 "2023-12-23T15:23:53Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![DougN\_Nouria](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Post date:** [December 23, 2023, 3:24pm UTC](https://community.cdata.com/t/cdc-ct-resynchronize-from-date/583/1 "2023-12-23T15:24:23Z")
I’ve been using Sync to pull from MS SQL Server, from a couple of different sources that have either CDC or Change Tracking enabled. Occasionally, there is some kind of hiccup where things get out of sync.  There are changes in the source that never replicated, but Sync thinks it’s already processed them, so it doesn’t try to catch up. For CDC-based jobs, I’d like an option to “Run with Resync”.  Supply a date, and have that be used as the basis point for Sync to look back.  Not whatever high water mark is stored in the internal Sync database. It would be OK if it applied the same look-back date to all the Tasks in the job.  It would be just for that one job execution. ---
**Author:** ![DougN\_Nouria](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Post date:** [December 23, 2023, 3:24pm UTC](https://community.cdata.com/t/cdc-ct-resynchronize-from-date/583/2 "2023-12-23T15:24:50Z")
(I know you can reset the job completely in a couple of different ways, but this causes the  **entire**  data set to be resynced, the full tables.  This could take hours or days.) ---
**Author:** ![Ankit\_Singh](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ankit_singh/32/1614_2.png) [@Ankit\_Singh](https://community.cdata.com/u/Ankit_Singh)\ **Post date:** [December 27, 2023, 8:03am UTC](https://community.cdata.com/t/cdc-ct-resynchronize-from-date/583/3 "2023-12-27T08:03:56Z")
Hey Doug, In the [Advanced Job Options](https://cdn.cdata.com/help/ASJ/sync/Advanced-Job-Options.html), there is a configuration for  **Replicate Start Value,**  which sets the minimum date/ int value (date in the form _yyyy-MM-dd_) from which to begin replication. Is this what you are looking for? ---
**Author:** ![DougN\_Nouria](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Post date:** [December 27, 2023, 1:23pm UTC](https://community.cdata.com/t/cdc-ct-resynchronize-from-date/583/4 "2023-12-27T13:23:04Z")
That doesn’t solve this problem fully, because one of my use cases requires forcing CData to reset its internal high-water mark.  I.e. Sync “thinks” it’s up-to-date, when in fact it is not.  Adding a start date wouldn’t really resolve that. Having said that, it would resolve some other scenarios.  I had inquired with tech support about a start date for replication, but they weren’t aware of any.  And the parameters in that help doc (Replication Interval, Replication Start Date) do not show up in my UI.  I’m on the latest version -  **Cross-Platform Edition - 23.3.8731.0**       I confirmed my job type is “change data capture”. ---
**Author:** ![Elsa\_X](https://avatars.discourse-cdn.com/v4/letter/e/278dde/32.png) [@Elsa\_X](https://community.cdata.com/u/Elsa_X)\ **Post date:** [January 12, 2024, 10:13am UTC](https://community.cdata.com/t/cdc-ct-resynchronize-from-date/583/5 "2024-01-12T10:13:19Z")
Hey Doug, To follow up on the conversation with Ankit and your feature request: Replicate Start Value, Replicate Interval, Replicate Interval Unit are options available only for _Standard Job Types_ , hence you are not able to see or use them with CDC Job type. There is no way to achieve what you’ve asked for with CDC jobs at the moment in a straightforward way; however, we could discuss this with the development team if it aligns with our current implementation and our Product roadmap. I do see having hiccups as the bigger issue though and something that must be addressed. From the support history, you seem to have been in touch with the support team lately, but please feel free to reach out if you’ve not done so regarding this matter, so we can have a look into it. ---
**Author:** ![DougN\_Nouria](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Post date:** [January 12, 2024, 12:58pm UTC](https://community.cdata.com/t/cdc-ct-resynchronize-from-date/583/6 "2024-01-12T12:58:27Z")
Thank you.  Yes, fixing the underlying bumps with my CDC/CT jobs would be the preferred solution.  🙂 For others - there is a parameter “'IgnoreUsingStatusTable” you can apply at the Job level, contact tech support for more info.  That worked for my use case.