Creating a Row Comparison Job

Set up a row comparison job.

Prerequisites

Verify that you have created a compareset.

Task

In the Perspective Resources view, select a Data Assurance server.
Select Resource > Administration Console.
Expand Data Assurance Server, then select Data Assurance Jobs.
Either:
- Select Folder > Create Job, or,
- Click the button that appears when you select Database Assurance Jobs, then select Create Job.

Specify the row comparison job basic information:

Field	Description
Data Assurance server	(Required) Name of the DA server from the drop-down list.
Name	(Required) Name of the row comparison job.
Active	Indicates that the row job can be run if selected.
Description	A brief description to help you identify the row comparison job.

Click Next or Option.
Enter the value for the maximum concurrent jobs.
This is the maximum number of jobs you want to run at the same time.
Click Next or Comparison.

Specify the general information for the current comparison you are setting up.

Field	Description
Name	(Required) Name of the comparison in a row comparison job.
Active	Indicates that the comparison job can be run if selected.
Description	A brief description to help you identify the comparison.
Priority	Priority level for the comparison.
Compareset	Name of the predefined compareset, which has the source and target tables to compare.

Note: You can create more than one comparison to a row comparison job, but doing so may result in slow performance. To do this, click Add Comparison.

(Optional) In the Comparison Options tab, modify or accept the default value for the comparison options.
(Optional) In the Column Options tab, modify or accept the default values on the column options for each column from the compareset.
(Optional) Click Next or Schedule.
(Optional) Click With Schedule (s) to set the schedule for this row comparison job. Or you can set the schedule later or run it manually.
Click Finish.