The CDC cleanup jobs on our Db's do not appear to be working. We have retention set to three days, experimented w/changing @threshold from 5000 all the way up to 250,000, all apparently to no avail.
Our cdc.dbo_xxx_CT tables have hundreds of thousands of rows. The insert date or last_updated columns in these tables date back a year!
Is there something I'm missing?
Thanks!