How can we have Data Capture automatically Failover with AlwaysOn?
We are implementing Data Capture with our AlwaysOn environment SQL 2014 CU4. When an automatic Failover occurred Data Capture did not automatically failover. Even though the SQL Agent Data Capture jobs were on the Secondary Node they did not automatically start. To fix the issue I set the SQL Agent Data Capture job to run every 5 minutes and check to see if the Server Is Primary. If it is primary it executes the sys.sp_MScdc_capture_job. Is there a better way to make Data Capture failover automatically with AlwaysOn?