sys.sp_cdc_stop_job

Description

Stops a change data capture cleanup or capture job for the current database.

Syntax

sys.sp_cdc_stop_job
[ [ @job_type = ]
N
'job_type'
]
[ ; ]

Permissions

06/23/2025 syntaxsql Type of job to add. @job_type is with a default of. Valid inputs are and. (success) or (failure). None. can be used by an administrator to explicitly stop either the capture job or the cleanup job.

Examples

Example 1

AdventureWorks2022

Example 2

USE
AdventureWorks2022;
GO
EXECUTE sys.sp_cdc_stop_job @job_type = N
'capture'
;
GO