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:
C:\Sybase\DA-15_5\server\instance\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.