sys.sp_cdc_start_job (Transact-SQL)
Applies to: SQL Server
Starts a change data capture cleanup or capture job for the current database.
Transact-SQL syntax conventions
sys.sp_cdc_start_job
[ [ @job_type = ] N'job_type' ]
[ ; ]
Type of job to add. @job_type is nvarchar(20) with a default of capture
. Valid inputs are capture
and cleanup
.
0
(success) or 1
(failure).
None.
sys.sp_cdc_start_job
can be used by an administrator to explicitly start either the capture job or the cleanup job.
Requires membership in the db_owner fixed database role.
The following example starts the capture job for the AdventureWorks2022
database. Specifying a value for @job_type isn't required because the default job type is capture
.
USE AdventureWorks2022;
GO
EXEC sys.sp_cdc_start_job;
GO
The following example starts a cleanup job for the AdventureWorks2022
database.
USE AdventureWorks2022;
GO
EXEC sys.sp_cdc_start_job
@job_type = N'cleanup';