I have enable the change data capture on db and enabled one table and i made updates on couple of records in the transaction table and it logged the changes of the enabled CDC table updates in teh default cdc table..
However to my surprise i didn't see the records which were logged in earlier day..
I have schedule the cleanup job after 60 days.
@job_type = N'cleanup',
@retention = 86400;
Please suggest if i missing anything which should not cleared the data after a day..
Thanks for your help in advance !