sys.sp_cdc_change_job

Description

Modifies the configuration of a change data capture cleanup or capture job in the current database. To view the current configuration of a job, query the Maximum number of transactions to process in each scan cycle. , which indicates no change for this parameter. If specified, the value must be a is valid only for capture jobs.

Syntax

sys.sp_cdc_change_job [ [ @job_type = ]
N
'job_type'
]
[ , [ @maxtrans = ] max_trans ]
[ , [ @maxscans = ] max_scans ]
[ , [ @continuous = ] continuous ]
[ , [ @pollinginterval = ] polling_interval ]
[ , [ @retention ] = retention ]
[ @threshold = ]
'delete threshold'
[ ; ]