SQL Server Error Code – 22994 the retention value specified for the ch

In this blog post, you’ll learn more about the SQL Server Error Code 22994 and the error message description that is shown

SQL Server Error Code

22994

SQL Server Error Description for the Code :22994

The retention value specified for the Change Data Capture cleanup process must be greater than 0 and less than or equal to 52594800. When creating or modifying the cleanup job, specify a retention value (in minutes) that is within that range. If this error is encountered when executing the sys.sp_cdc_cleanup_change_table stored procedure, reset the retention value associated with the job to a non-negative value less than 52594800 by using the sp_cdc_change_job stored procedure.