tencent cloud

TencentDB for SQL Server

DocumentationTencentDB for SQL ServerOperation GuideData Synchronization (DTS) Pre-check Failure HandlingChecking CDC Tasks

Checking CDC Tasks

Download
Focus Mode
Font Size
Last updated: 2026-06-04 15:21:02
AI-Translated

Check Details

Check objective
Ensure the CDC capture task runs properly.
Feature Description
A check for CDC Job query permissions has been added (Checker phase).
A CDC monitor has been added in the River phase to periodically check the status of CDC Capture Jobs.
When a CDC Job failure is detected, the capture task is automatically restarted.
After multiple consecutive detection failures, the synchronization task is automatically stopped and an alarm is raised.
Monitoring Configuration
Check interval: 10 minutes by default.
Maximum number of retries: 3 by default.
Failure record check window: 15 minutes by default.
Permission Requirements
Required: The db_datareader role on the msdb database (for querying msdb.dbo.cdc_jobs and msdb.dbo.sysjobhistory).
Optional: The VIEW SERVER STATE permission (used to check the SQL Server Agent status, and automatically skipped if the permission is absent).

Fixing Method

The following permissions are required.
Required: The db_datareader role on the msdb database (for querying msdb.dbo.cdc_jobs and msdb.dbo.sysjobhistory).
Optional: The VIEW SERVER STATE permission (used to check the SQL Server Agent status, and automatically skipped if the permission is absent).
Previous Topic: Checking Encrypted ObjectsNext Topic: Creating a Data Consistency Check Task

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback