create procedure sys.sp_cdc_get_job_parameters
(
@pollinginterval bigint output,
@continuous bit output,
@maxscans int output,
@maxtrans int output
)
with execute as 'dbo'
as
begin
set nocount on
if (object_id('msdb.dbo.cdc_jobs') is null) or
not exists
(
select *
from msdb.dbo.cdc_jobs
where database_id = db_id()
and job_type = N'capture'
)
begin
raiserror(22997, 16, -1, N'capture')
return (1)
end
select @pollinginterval = pollinginterval
,@continuous = continuous
,@maxtrans = maxtrans
,@maxscans = maxscans
from msdb.dbo.cdc_jobs
where database_id = db_id()
and job_type = N'capture'
return 0
end
-- Name: sp_MScdc_capture_job
-- Descriptions: This proc calls sp_cdc_scan pulling the parameters to
-- drive execution from msdb.dbo.cdc_jobs
-- Parameters:
-- none.
-- Returns: 0 - success
-- 1 - Otherwise
-- Security: public, sysadmin or DBO only
raiserror(15339,-1,-1,'[sys].[sp_MScdc_capture_job]')