Job event metadata are stored in the Teradata PT private log called TWB_EVENTS. These metadata provide timely and granular operational information, which includes event detection and notification at different levels and stages of Teradata PT jobs. Event data can be used to perform event analysis, enabling you to streamline and automate as many of the operational procedures as possible. Some examples of event metadata include:
- Rows processed since job start
- Rows processed since the last checkpoint
- Rows checkpointed since job start
- Rows applied to the target tables
- CPU time used by each operator since job start
- Elapsed time since job start (how long it has been running)
- Start and End of data acquisition and data application phases
- Start and end of a job
- Job step that has finished execution or encountered an error
- Storage fragmentation has reached a high-water mark
- Shared memory usage has reached a high-water mark
- Job termination request received from user