Each finished job generates a job report that includes information about the parameters used to compare source and target databases, and the results of the comparison.
The report is stored in text and XML file formats, in the
data subdirectory under the Replication Server Data Assurance Option installation directory. The
data directory is further classified by job name and timestamp for each job . For example:
D:\code\da_instance_view\calm\dub\da\DA\server\localhost\data\job2\2010-10-13\14.38.11.762\report.txt
where:
- job2 – specifies the job name.
- 2010-10-13 – specifies the date when the job was submitted.
- 14.38.11.762 – specifies the time, in hours, minutes, seconds and milliseconds, when the job was submitted.
Each report file provide detailed information, which includes:
- Comparison options used
- Number of rows compared
The report files are generated when you run:
show history jobname historyid
If
create_col_log is set to true, the XML and text report files contain the details of every difference.