During the course of administering CA Client Automation you may run into issues where software jobs may hang or become corrupt. If this happens a manual cleanup may be required. This document outlines the Software Delivery/Data Transport Service cleanup procedure (AKA SDO/DTS cleanup) required to correct these issues.
All Supported Windows operating systems
All Supported CA Client Automation versions
8. Delete all the files in the "..\CA\DSM\DTS\DTA\Staging" folder.
In addition to the cleanup of the files, attached is a script to cleanup the USD database tables. The script should help get rid of any anomalies in the USD tables.