dbo.cdc_jobs (Transact-SQL)


Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Stores the change data capture configuration parameters for capture and cleanup jobs. This table is stored in msdb.

Column nameData typeDescription
database_idintThe ID of the database in which the job is run.
job_typenvarchar(20)The type of job, either 'capture' or 'cleanup'.
job_iduniqueidentifierA unique ID associated with the job.
maxtransintThe maximum number of transactions to process in each scan cycle.

 maxtrans is valid only for capture jobs.
maxscansintThe maximum number of scan cycles to execute in order to extract all rows from the log.

 maxscans is valid only for capture jobs.
continuousbitA flag indicating whether the capture job is to run continuously (1), or run in one-time mode (0). For more information, see sys.sp_cdc_add_job (Transact-SQL).

 continuous is valid only for capture jobs.
pollingintervalbigintThe number of seconds between log scan cycles.

 pollinginterval is valid only for capture jobs.
retentionbigintThe number of minutes that change rows are to be retained in change tables.

 retention is valid only for cleanup jobs.
thresholdbigintThe maximum number of delete entries that can be deleted using a single statement on cleanup.

sys.sp_cdc_add_job (Transact-SQL)
sys.sp_cdc_change_job (Transact-SQL)
sys.sp_cdc_help_jobs (Transact-SQL)
sys.sp_cdc_drop_job (Transact-SQL)

Community Additions