Suspended table notifications recur on an interval
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?
NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.
.png "Former Employee"){kind=icon}