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).