Data Assurance Jobs

A Data Assurance (DA) job can be a row comparison or a schema comparison.

When creating a row comparison job you specify the compareset to use and set the schedule for running the job. You can set to run a row comparison job based on days, weeks, or months, or you can run it manually. The schema comparison job is run manually and cannot be scheduled.

You can also create a row comparison job based on Replication Server System Database (RSSD) by importing table-level replication definition and subscription from an RSSD in an SAP Replication Server.

See the Replication Server Data Assurance Option Users Guide > Replication Server Data Assurance Option > Jobs and Comparisons.

• Row Comparison Jobs
  A row comparison sorts rows by a primary or a unique key, from all participating database tables and compares them one by one. A comparison summary is stored in the Data Assurance System Database (DASD). Detailed text or XML reports showing the row differences are stored in the data directory.
• Schema Comparison Jobs
  Schema comparison lets you compare the schema of one primary database against one or more replicate databases. You can compare an entire database schema using automatic table name mapping, or you can compare specific tables using table name mapping.