sys.sp_cdc_add_job

Description

Creates a change data capture cleanup or capture job in the current database. Flag indicating whether the job should be started immediately after it’s added. Maximum number of transactions to process in each scan cycle. If specified, the value must be a positive integer. is valid only for capture jobs.

Syntax

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