I am trying to perform the below CDC operation. My CDC job schedule is set for every 30 seconds on a table. During heavy traffic the CDC job takes more than 30 seconds so I have set it up to be killed if it takes more than 28 seconds(else it gets hung up). So when the kill(timeout on TAC) occurs I want the operation to be rolled back instead of partially committing.
When the process gets killed due to timeout do we have error at every component level???
As you can see that if it has passed a certain stage then will the component that has successfully been processed throw an error too?? I want the complete job to be rolled back. Please let me know what you suggest in such situations.
Attached is the screenshot below.