Transaction Behavior
The agent utilizes a unique Transaction ID to ensure that the inserted (distributed) rows are removed incase the batch is cancelled. This is to avoid duplicated rows.
To handle this, the agent inserts the unique batch Transaction ID in the assigned Transaction ID column. If the batch is cancelled, all rows matching the batch Transaction ID will be removed again.
Emits
This agent does not emit anything.
Retrieves
The agent retrieves commands from other agents and based on them generates a state change of the file currently processed.
Command | Description |
---|---|
Begin Batch | Retrieves a new Transaction ID. |
End Batch | Do nothing. |
Cancel Batch | Removes the distributed rows with the current Transaction ID or calls the configured Cleanup SP. The pending Transaction ID row is deleted. |
Add Comment