show reconcile

Generates and shows the reconciliation script path for a job with a specified history ID.

Syntax

show reconcile job_name historyid

show reconcile is applicable only to row comparison jobs; it does not work with schema comparison jobs.

Parameters

job_name – the name of the job for which to show the reconciliation script.
historyid – the job history sequence ID of the reconcile script to be shown.

Examples

Example 1 – generates the reconciliation script for “job6” with history ID 29:

show reconcile job6 29
go

The returned result is:

COMPARISON TARGET RUN SUBMIT TIME FINISH TIME RECONCILE SCRIPT
---------- ------ --------------- ----------- -----------------
 cmp6     soka3:5000/dadb.dbo.da1_10m  1   2010-10-15 14:04:04.573
2010-10-15 14:04:04.573       N/A

                                        2   2010-10-15 14:04:15.12
2010-10-15 14:04:15.136        N/A

                                        3   2010-10-15 14:04:25.683
2010-10-15 14:04:25.696        N/A

                                        4   2010-10-15 14:04:26.26
2010-10-15 14:04:28.73
D:\code\da_zhuj_view\calm\dub\da\DA\server\localhost\data\job6
\2010-10-15\14.04.03\cmp6_0_recon.sql
(0 rows affected)