I have enabled cdc and using it , it works fine now the problem is that we have many tables in a database and also we have many databases so how to configure cdc cleanup job to run again and again after a specific time , I read this article tried what he said but its not working for me .
I also tried this SP sp_MScdc_cleanup_job , I executed this it clean all data but i need it to be automatic
Let suppose i want to run it every minute just for check that its running or not , What should i do ?
Aucun commentaire:
Enregistrer un commentaire