August 13, 2025 at 3:59 pm
Good morning,
I've noticed my CDC job running for 17 days. I've noticed it before, but wasn't sure it was an issue. I've checked sys.databases to check the log_reuse_wait_desc to see if it said "replication". It says nothing.
The Database is 8 TB and the log file is 23 GB.
I queried : SELECT job_id, continuous FROM msdb.dbo.cdc_jobs WHERE job_type = 'capture'; The resultset is 1
For clarity and peace of mind, is 17 days running for CDC capture normal?
Thanks.
Things will work out. Get back up, change some parameters and recode.
August 14, 2025 at 7:55 am
Yes, the CDC job should be running 24x7x365 if it is in continuous mode so it is always reading the T-LOG to keep it as trim as possible.
August 14, 2025 at 2:29 pm
Thank you!
Things will work out. Get back up, change some parameters and recode.
August 19, 2025 at 10:27 am
Good morning,
I've noticed my CDC job running for 17 days. I've noticed it before, but wasn't sure it was an issue. I've checked sys.databases to check the log_reuse_wait_desc to see if it said "replication". It says nothing.
The Database is 8 TB and the log file is 23 GB.
I queried : SELECT job_id, continuous FROM msdb.dbo.cdc_jobs WHERE job_type = 'capture'; The resultset is 1
For clarity and peace of mind, is 17 days running for CDC capture normal?
Thanks.
As long as you are not seeing any bottleneck due to those jobs and long running open transactions from those process its fine. As Ant-Green rightly said it will run forever untill you do a restart on instance or agent or job.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply