CHANGE DATA CAPTURE SQL Errors 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. By deviprasad