Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

sys.sp_cdc_help_jobs (Transact-SQL)

Reports information about all change data capture cleanup or capture jobs in the current database.

Topic link icon Transact-SQL Syntax Conventions

sys.sp_cdc_help_jobs

0 (success) or 1 (failure)

Column name

Data type

Description

job_id

uniqueidentifier

The ID of the job.

job_type

nvarchar(20)

The type of job.

maxtrans

int

The maximum number of transactions to process in each scan cycle.

maxtrans is valid only for capture jobs.

maxscans

int

The maximum number of scan cycles to execute in order to extract all rows from the log.

maxscans is valid only for capture jobs.

continuous

bit

A 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.

pollinginterval

bigint

The number of seconds between log scan cycles.

pollinginterval is valid only for capture jobs.

retention

bigint

The number of minutes that change rows are to be retained in change tables.

retention is valid only for cleanup jobs.

threshold

bigint

The maximum number of delete entries that can be deleted using a single statement on cleanup.

Requires membership in the db_owner fixed database role.

The following example returns information about the defined capture and cleanup jobs for the AdventureWorks2012 database.

USE AdventureWorks2012;
GO
EXEC sys.sp_cdc_help_jobs;
GO
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.