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]')