Recently had a customer with a task where some of the tables suspended due to an error. The task kept running because other tables where still processing CDC changes without problem.
An email notification was sent, but was missed from the users on call at the time.
A few days passed and because the task was still running without issue, it took some time to understand the tables were no longer sending changes to the target.
Is it possible to set up a notification on a recurring interval at the task level showing tables are in a suspended state?
Thanks,
Kelly
.png "Former Employee"){kind=icon}