tencent cloud

TencentDB for SQL Server

DocumentaçãoTencentDB for SQL ServerOperation GuideData Synchronization (DTS) Pre-check Failure HandlingChecking CDC Tasks

Checking CDC Tasks

Baixar
Modo Foco
Tamanho da Fonte
Última atualização: 2026-06-04 15:21:02

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).
Anterior: Checking Encrypted ObjectsPróximo: Creating a Data Consistency Check Task

Ajuda e Suporte

Esta página foi útil?

comentários