Sample Header Ad - 728x90

CDC cleanup job -- history

0 votes
1 answer
196 views
On SQL Server 2019, I enabled CDC on some tables about 2 days ago. The CDC cleanup job is scheduled to run every day and the retention period is 3 days. When I checked the job history of the cleanup job, I found nothing there. I ran the job manually and by the next day I found that even the manual job I ran was no longer there. How can I be sure that the cleanup job is running as it should, also could there be anything that is clearing the job history? The database is also part of always-on availability group. Please, help.
Asked by dennis (1 rep)
Jul 26, 2024, 05:20 PM
Last activity: Jun 29, 2025, 07:03 AM