show history

Shows the history, including the report file and reconciliation file path, for a single job.

Syntax

show history job_name[historyid]

Parameters

job_name – the name of the job for which to show history.
historyid – the job history sequence ID.

Examples

Example 1 – shows “job2” history:

show history job2
go

The returned result is:

HISTORY ID SUBMIT TIME             FINISH TIME
---------- ----------------------- ----------------------
12         2010-10-13 14:38:11.783 2010-10-13 14:38:19.41

Example 2 – shows history for “job2” with history ID 12:

show history job2 12  
go

The returned result is:

COMPARISON RUN  PHASE       TYPE   SUMMARY                         START TIME      
---------- ---- ---------   ---  -------------------------------   ------------ 
END TIME           COUNT READ   M O I   RECON ERROR
--------            ----------  -- -- -- --------------- 

 c1         1   COMPARE_ALL  S    MACHINEXP1:5000/test.dbo.mycash  2011-02-22 16:09:54 
2011-02-22 16:09:54 3     3
                             T    MACHINEXP1:5000/test.dbo.mycash2 2011-02-22 16:09:54 
2011-02-22 16:09:54 3     3    0 0 3
            2   RECHECK_DIFFERENCES  T                              2011-02-22 16:09:59 
2011-02-22 16:09:59       3    0 0 3
            3   VERIFY_DIFFERENCES           S                      2011-02-22 16:10:00 
2011-02-22 16:10:00       3
                                             T                      2011-02-22 16:10:00 
2011-02-22 16:10:00       3    0 0 3
            4   CREATE_RECONCILIATION_SCRIPT T                      2011-02-22 16:10:00 
2011-02-22 16:10:00                  0
            5   APPLY_RECONCILIATION         T                       2011-02-22 16:10:00 
2011-02-22 16:10:00                 0
(0 rows affected)

FILE          SERVER PATH
------        --------------
Recon script  D:\code\da_instance_view\calm\dub\da\DA\server\localhost\.\data\job2\2011-02-
              22\14.38.11\c1_T_recon.sql
Text report          D:\code\da_instance_view\calm\dub\da\DA\server\localhost\.\data\job2\2011-02-
              22\14.38.11\report.txt
(0 rows affected)

Note: Executing show history generates the text and XML reports, if they have not already been generated, before showing the output. The more the differences, show history takes a longer time to generate the reports, which causes a delay in showing the results.