Starts a change data capture cleanup or capture job for the current database.
Applies to: SQL Server (SQL Server 2008 through current version).
A. Starting a capture job
The following example starts the capture job for the AdventureWorks2012 database. Specifying a value for job_type is not required because the default job type is capture.
USE AdventureWorks2012; GO EXEC sys.sp_cdc_start_job; GO
B. Starting a cleanup job
The following example starts a cleanup job for the AdventureWorks2012 database.
USE AdventureWorks2012; GO EXEC sys.sp_cdc_start_job @job_type = N'cleanup';