show reconcile

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 – shows 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       myhost: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:26.26 
    2010-10-15 14:04:28.73    C:\Sybase\DA-15_5\server\instance\data
\job6\2012-05-10\14.04.03\cmp6_0_recon.sql
(0 rows affected)