sql server - How the cdc retention value can be changed for the cleanup job? -

I am implementing the logging feature on an asp.net mvc2 application, which is a database and entity framework as SqlServer2008 Uses the data model

I have enabled the SqlServer CDC feature and it is changing well in logging, but I noticed that some old logging data has been erased.

Does anyone know what the default period is the CDC record, and anyone knows how I can set it for an uncertain value. I just got to know that the default retention value is 4320 minutes = 72 hours = 3 days

It should be configured using

  sp_cdc_change_job @job_type = 'cleanup', @ retention = minutes  

Maximum value is 524 9 4800 (100 years). If specified, the value should be a positive integer. Retention is valid only for cleanup jobs.

Here is the sp_cdc_change_job process

Hope this will help anyone else: D.