Viewing Completed Jobs

To view the near-real-time information about completed jobs, click Monitor Jobs in the navigation pane, and select the Completed Jobs tab.

This page displays details of all the completed jobs:

• Comparison Status: The status of the comparison.

• Repair Status: The repair status of the comparison. It is Successful, Failed, or left blank when the repair job is not run.

• Name: The name of the job.

• Start Time: The job process start time.

• End Time: The job process end time.

• Run Duration: Time taken to process the job.

• Compare Pair Total: The total number of compare pairs in the job.

• Out-of-Sync Compare Pairs: the number of compare pairs that are out of sync.

• Failed Compare Pairs: The number of compare pairs failed in this comparison.

• Cancelled Compare Pairs: The number of compare pairs cancelled.

• Report: Click this link to view the job report.

• Actions: You can delete the Run information of the job.

To delete mutiple jobs, select the jobs from the list and click Delete.

By default, this page shows all the jobs that are processed. Use the Time Range Filter to constrain the view as needed.

To use the Time Range Filter

• Most Recent Comparison Run: Selects the most recent run for each job that exists.

• View Last: Selects all of the runs of all of the jobs that started within the last <n> Hours or Minutes.

• From: Selects all of the runs of all of the jobs that finished within a specific date range, with the option to include the time of day. Supply date and time values.

Click Apply to activate your selection.

Basic filter options

You can filter by:

• Comparison Status: show all jobs (default) or constrain the list based on jobs with a specific comparison status.

  Possible comparison status conditions:

  • In Sync

  • Out-of-Sync

  • Failed

  • Skipped

  • Cancelled

• Repair Status: show all jobs (default) or constrain the list based on jobs with a specific repair status.

  Possible repair status conditions:

  • Pending

  • Running

  • Out-of-Sync

  • Successful

  • Failed

  • Warning

  • Cancelled

More Details

Click an invidual job name in the list to view:

• Job Summary: Displays the overall job summary, Compare Pairs Run Summary chart, and the list of compare pairs. Click a compare pair name to view the Compare Pair Details, Performance, and the Report tabs.

  • Compare Pair Details section:

    • Displays a chart view of the comparion details and a graph view of the out-of-sync operations.

    • Displays the Out-of-Sync and Skipped Row Details, which you can filter by Status, Operation, or Columns.

    • You have an option to download Repair SQL or to repair the compare pair.

      Note: Download Repair SQL option is available only for Jobs that have been configured for datasource connections with the Oracle datatype.

  • Performance: Displays the comparison performance details at different comparison stages such as Sorting, Initial Compare, and Confirm Out-of-sync. The page also displays a graph view with the performance details for each stage, which you can filter based on:

    • Run Duration

    • Rows Processed

    • Rows Per Second

  • Report: Displays the following details about the selected comparison:

    • Overiew

    • Profile

    • Parameters

    • Agent Info

    • Performance Stats

    • Sort Statistics

    • Summary

    You can download the individual comparison report for a selected compare pair, from this page.

  • From the Job Summary page, click More Actions for the Repair and Download Repair SQL options.

  • Click Run Job, to run the current job again.

• Out-of-Sync Summary: Displays the out-of-sync details at each group and compare pair levels. You can filter the details by:

  • Groups

  • Status

  • Operation

  • Columns

  You can also download the Repair SQL or repair the target from this page.

• Report: Displays the the report for a specific job, group, or compare pair. The report shows processing results and the causes of errors:

  • Results

  • Overiew

  • Profile

  • Run Options

  • Summary

  You can download the following reports from this page:

  • Overall Job Report

  • Job and Compare Pairs Reports