I have two SQL Servers that are linked through Pub/Sub CDC.
The Pub Server has a CDC-enabled table. This table receives a nightly batch of data (CRUD via Informatica ETL).
The Sub Server has an identical table and receives the data via standard Merge replication.
When the nightly batch is complete, CDC takes over and the Sub Server gets the data from the transaction logs as normal. This runs nominal and I have no problems here.
I have been asked to perform follow-on operations via a schedular (think airflow, or something similar).
My question is: is there a place in SQL Server that will either illuminate or that I can POLL that will tell me when the cdc update to the Sub server is complete? I am assuming no more changes until the batch is started in 24 hours.