Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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';
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today