Read more about the article CDC Cleanup job
Microsoft SQL Server

CDC Cleanup job

An introduction to CDC can be found here.

All data modifications in a CDC enabled table are saved in a separate change table. But in order to limit the size of this change table, a SQL Agent job is automatically created, named cdc.XXX_cleanup, that deletes rows older than the configurable “retention value”. The job is created once per database at the moment when CDC is enabled.

(more…)

Continue ReadingCDC Cleanup job