Teradata PT applies the following rules to error tables:
- Since Teradata PT automatically creates error tables each time a job runs, the error tables from the previous job run must be dropped before the next time the job runs.
- Teradata PT automatically drops error tables for successful job runs, that is, job runs with an exit code of 0 or 4. This includes jobs that succeed on the first run, as well as those that succeed after being repaired and rerun.
- Teradata PT does not automatically drop error tables for jobs that terminate with an exit code of 8 or 12 (to allow use of the error tables for debugging the job), or if the DropErrorTable is set to No.