Today, in Enterprise Manager there is a service that notifies the user when the task has high latency, there is also a task scheduling service, but there is no service that combines these two features.
Scenario: Our cloud database is used as both a source endpoint and a target endpoint. As it is a cloud database, there is instability in the connection of this database, which is identified after the application latency increases and does not improve. For this type of problem, restarting the task in “Resume Processing” mode re-establishes the connection to the cloud database. However, if the connection loss happens in the early hours of the morning, for example, it will not be possible to take actions in a timely manner to solve the problem.
Resources to solve the above problem:
- Create a service that takes action after latency on a task exceeds a certain time:
- Restart task in Reload Target mode
- Restart the task in Resume Processing mode
- Restart the task starting to process changes from a given datetime
