View Job History
You can use DataZen Manager to inspect the history of a job, including the log output of each execution, their status, key performance metrics, and the resulting change logs.
Metrics
The following metrics are available:
- Execution Id: a unix-style timestamp when the job started
- Records Read: number of records read from the source system, if the job is a reader
- Records Available: number of records available after the change data capture map-reduce operation (if applicable), if the job is a reader
- Records Updated: number of records updated in the target system, if the job is a writer or a Direct Job
- Records Deleted: number of records deleted in the target system (if applicable), if the job is a writer or a Direct Job
- Read + Write Time: total time spend reading and writing, if the job is a Direct Job
- Read Time: total time spend reading, if the job is a Job Reader
- Write Time: total time spend writing, if the job is a Job Writer
- Map-Reduce Time: total time spend performing the change capture map-reduce operation (if applicable), if the job is a Job Reader or a Direct Job
- Start Time: the datetime when the job started
- End Time: the datetime when the job completed
- Runtime: the total duration of the job
- Package File: the location of the change log (if applicable)
- Error Message: the last error message (if applicable)
By default, the first 5000 records successful job results are displayed.
Filters
You can change the filters to view all job executions, relevant executions (successful with records available and errors), or only the executions that failed. You can also modify the number of records returned.
Detailed Log
The Detailed Log tab shows the job output for the selected execution. This output can be helpful to troubleshoot issues if multiple errors are logged. When inspecting a Direct Job, this output shows the log of both the Reader and Writer operation. However, if a trigger has been defined on the job, this output will not show the log of the jobs that have been triggered.
