Running a Job

Jobs are executed from the Run/Execute Job page. Any job that has been previously configured can be run from this page. Before running a job, you may want to estimate its duration (see Estimating Comparison Time).

To run a job without modification:

For Job, select a job from the drop-down list or click the Browse button to open the Select a Job page, where you can use filters to constrain the selection choices. See Selecting a Job.
(Optional) For Job Profile, select a profile if you want it to override the profile that is linked to this job. You can select from the drop-down list or click the Browse button to open the Select a Profile page, where filters are provided.
Click Run Job. By default, all compare pairs that are linked to the selected job will be processed, even though their names do not appear in the Compare Pairs list (see Existing Compare Pairs).

To Modify a Job Before Running It

After selecting the job and (optional) profile, click Retrieve Compare Pair List. All of the compare pairs in the job are displayed in the Compare Pairs list, and all are selected by default.

The compare pairs are organized according to the groups that contain them, with the groups listed in alphabetical order.

The following information is displayed in the Compare Pairs list. This information can help you to refine the job configuration.

Name of the Column	Description
Select	Allows you to select compare pairs.
Previous Comparison Status	Indicates the results of the previous comparison run of the compare pair.
Row Partitions	Enables you to configure or override row partitions (see the steps below).
Previous Run Duration	The length of time that the previous comparison took. Can be used as a basis for estimating the duration of the next comparison.
Compare Pair Name	The name of the compare pair. To view actual object names, hover the mouse over the name.
Previous Number Rows Compared	The number of rows that were compared in the previous run.
Previous Number Rows Out Of Sync	The number of rows that were out of synchronization in the previous run.
Delta Base Time	Shows the end time of the previous comparison, which provides a start time on which to base delta processing for the next run.
Previous Comparison Reports	Links to comparison reports from previous runs.

Filter the list, if necessary.
To filter the list of compare pairs, expand Filters to expose filter options. You can filter the list of compare pairs by the following:
- Group Names Like: Type a search string to show names that contain the string.
- Compare Pairs: You can filter compare pairs based on their previous comparison status.
- Compare Pair Name Like: Type a string to filter by the name of the compare pair.
- Source Table Name Like: Type a string to filter by the name of the source table or file.
- Target Table Name Like: Type a string to filter by the name of the target table or file.
After you specify your filter criteria, click Apply Filter. By default, all items that the filter returns are selected for processing.
Select the compare pairs that you want to be processed in this job.
- To select all of the compare pairs (in all of the groups) in the list, make certain that the All check box displays a check mark. (This box is located directly above the Compare Pairs header.) This action affects only the compare pairs that are in the list, not any that were excluded by means of the filter.
- To deselect all of the compare pairs in the list, clear All. To deselect all when some pairs are selected and others are not, you might need to click All twice, once to select all and once to deselect all.
- To select all of the compare pairs that are in a given group, click the Select box beneath the name of the group.
- To include or exclude an individual compare pair, select or clear the Select box next to its name.
To set the Delta Base Time value, click the automatically selected value or Select..., then see Selecting Delta Base Time.
If delta processing is enabled for any of the compare pairs in this job, the Delta Processing Enabled check box is shown. To disable delta processing, clear the check box.
To configure or override row partitions, click Configure... in the Row Partitions column to open the row partitions editor.
To change the default job attributes and profile parameters, click the Set Override Run Options link to go to the Run Options page (see Overriding Run Options).

Note:

The Command Line To Be Used box shows the underlying vericom command that will be used to run this job. For more information about vericom, see the Oracle GoldenGate Veridata Administrator Guide.
The Run Repair Automatically after Compare check box is displayed when the job is out-of-sync and the user has repair operator role.
Click Run Job.

Estimating Comparison Time

When tables are large, you might want to estimate the amount of time that a comparison will take before running a full comparison. To get an estimate, run a test comparison of a limited number of rows. For example, if there are 100 million rows in a table, you can run a comparison for the first million rows and then multiply that amount of time by 100.

To specify the number of rows compared

On the navigation pane, click Profile Configuration.
On the list, click the name of the profile that is linked to the job (or select it, and then click Edit). The Edit Profile page is displayed.
Click Initial Compare.
Under General, clear the Use Default box for the Limit Number of Input Rows setting, and then type the number of rows that you want to compare.
After running the test comparison, change Limit Number of Input Rows back to the default for the full comparison run.