sys.sp_cdc_help_jobs (Transact-SQL)

Applies to: SQL Server

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

Syntax

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 AdventureWorks2022 database.

USE AdventureWorks2022;
GO

EXEC sys.sp_cdc_help_jobs;
GO