The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_cdc_change_job(nvarchar @job_type, int @maxtrans
, int @maxscans
, bit @continuous
, bigint @pollinginterval
, bigint @retention
, bigint @threshold)
MetaData:
create procedure sys.sp_cdc_change_job ( @job_type nvarchar(20) = N'capture', @maxtrans int = null, @maxscans int = null, @continuous bit = null, @pollinginterval bigint = null, @retention bigint = null, @threshold bigint = null ) as begin set nocount on declare @retcode int ,@db_name sysname set @db_name = db_name() -- -- Job security check proc -- exec @retcode = [sys].[sp_MScdc_job_security_check] if @retcode <> 0 or @@error <> 0 return(1) -- Verify database is currently enabled for change data capture if ([sys].[fn_cdc_is_db_enabled]() != 1) begin raiserror(22901, 16, -1, @db_name) return 1 end set @job_type = rtrim(ltrim(lower(@job_type))) -- Verify parameter if @job_type not in (N'capture', N'cleanup') begin raiserror(22992, 16, -1, @job_type) return(1) end -- Call internal stored procedure to complete verification and update job attributes exec @retcode = sys.sp_cdc_change_job_internal @job_type, @maxtrans, @maxscans, @continuous, @pollinginterval, @retention, @threshold if @@error <> 0 or @retcode <> 0 return 1 return 0 end
No comments:
Post a Comment