A value for the parameter @retention cannot be specified when the job type is ‘capture’. Specify NULL for the parameter, or omit the parameter from the statement.

Posted on : 22-10-2013 | By : Devi Prasad | In : CHANGE DATA CAPTURE, SQL Errors

Share:

0


The Parameter @retention should NOT be supplied with a NOT NULL value when the value of @job_type is ‘capture’

EXEC sp_cdc_change_job @job_type='capture',@maxtrans = '10000',@retention=200

The above code gives the below error.


Msg 22995, Level 16, State 1, Procedure sp_cdc_change_job_internal, Line 39
A value for the parameter @retention cannot be specified when the job type is ‘capture’. Specify NULL for the parameter, or omit the parameter from the statement.

Resolution:

Remove @retention input parameter.

EXEC sp_cdc_change_job @job_type='capture',@maxtrans = '10000'
(Visited 50 times, 1 visits today)



References : Devi Prasad (sqlserverlearner.com)

Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.


Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.




Write a comment



Tags: ,