show history

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

Syntax

show history
[job_name  
	[ {history_id | latest
      [ {comparison_name | summary }]
        [where where_argument]
] ]

Parameters

job_name – the name of the job for which to show history. If a job name contains optional wildcards, it acts as a filter.
history_id – the job history sequence ID.
latest – indicates the job history with the highest sequence ID.
comparison_name – the comparison name filter to show job history. If the comparison name contains optional wildcards, all matching comparisons are shown.
summary – shows the history in a summary format, in which the history for all comparisons is summarized into a single row.
where – the where argument to filter the job history.

where Agruments
where Argument	Description
differences	Shows only the comparisons that found one or more missing, inconsistent, or orphaned rows
missing	Shows only the comparisons that found one or more missing rows
inconsistent	Shows only the comparisons that found one or more inconsistent rows
orphaned	Shows only the comparisons that found one or more orphaned rows
reconciliation	Shows only the comparisons that reconciled one or more rows
errors	Shows only the comparisons that encountered one or more errors

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 set:

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)
COMPARISON TARGET RECONCILIATION SCRIPT 
---------- ------ ----------------------------------------------------------------------------------------
c          0      C:\Sybase\DA-15_5\server\instance\data\job2\2012-10-05\09.11.28.585\c1_T_recon_ins.sql
                  C:\Sybase\DA-15_5\server\instance\data\job2\2012-10-05\09.11.28.585\c1_T_recon_upd.sql
                  C:\Sybase\DA-15_5\server\instance\data\job2\j1\2012-10-05\09.11.28.585\c1_T_recon_del.sql

Example 3 – shows the number of histories for each job:

show history
go

JOB NAME     HISTORIES
-----------  ---------
custTables   3
stockTables  12
test1        2

(0 rows affected)

Example 4 – shows the individual history items for the job named custTables:

show history custTables
go

HISTORY ID   SUBMIT TIME           FINISH TIME
----------   -------------------   -------------------
42           2012-07-13 11:24:43   2012-07-13 11:25:51
39           2012-07-12 10:18:01   2012-07-12 10:19:11
37           2012-07-11 10:33:12   2012-07-11 10:34:20

(0 rows affected)

Example 5 – shows a summary of history item 42 for the job named custTables:

show history custTables 42 summary
go


SUBMIT TIME         FINISH TIME         COMPARISONS READ (S) DIFFS M O I  R  ERRORS
------------------- ------------------- ----------- -------- ----- - - -- -- ------
2012-07-13 11:31:56 2012-07-13 11:32:44 3           30045    45    0 0 45 45 0

(0 rows affected)

Using the latest keyword is equivalent to using the highest history ID. This command is equivalent to the command above:

show history custTables latest summary
go

Example 6 – shows the latest history for the job named test1:

show history test1 latest
go

COMPARISON RUN PHASE       TYPE SUMMARY                      START TIME          END TIME            COUNT READ M O I R ERROR
---------- --- ----------- ---- ---------------------------- ------------------- ------------------- ----- ---- - - - - -----
c          1   COMPARE_ALL S    zeus:5000/myasedb.dbo.test1  2012-07-17 16:35:38 2012-07-17 16:35:39 1     1
                           T    hera:1521/qsora11g.QA1.TEST1 2012-07-17 16:35:38 2012-07-17 16:35:39 1     1    0 0 0
	
(0 rows affected)

Example 7 – shows the latest history for the job named stockTables, showing only the comparisons that encountered some differences:

show history stockTables latest where differences
go

COMPARISON RUN PHASE                        TYPE SUMMARY                    START TIME          END TIME            COUNT READ  M O I  R  ERROR
---------- --- ---------------------------- ---- -------------------------- ------------------- ------------------- ----- ----- - - -- -- -----
sku        1   COMPARE_ALL                  S    prod1:5000/stockdb.dbo.sku 2012-07-13 11:32:18 2012-07-13 11:32:20 N/A   10000
                                            T    back1:5000/stockdb.dbo.sku 2012-07-13 11:32:18 2012-07-13 11:32:19 N/A   10000 0 0 15
                                            T2   back2:5000/stockdb.dbo.sku 2012-07-13 11:32:18 2012-07-13 11:32:20 N/A   10000 0 0 0
           2   RECHECK_DIFFERENCES          T                               2012-07-13 11:32:29 2012-07-13 11:32:30       15    0 0 15
                                            T2                                                                       N/A
           3   VERIFY_DIFFERENCES           S                               2012-07-13 11:32:30 2012-07-13 11:32:30       15
                                            T                               2012-07-13 11:32:30 2012-07-13 11:32:30       15    0 0 15
                                            T2                                                                       N/A
           4   CREATE_RECONCILIATION_SCRIPT T                               2012-07-13 11:32:30 2012-07-13 11:32:30                    15
                                            T2

(0 rows affected)


COMPARISON TARGET RECONCILIATION SCRIPT
---------- ------ --------------------------------------------------------------------------------------
sku        0      C:\Sybase\DA-15_5\myserver\data\stockTables\2012-07-13\11.31.56.007\sku_T_recon_upd.sql

(0 rows affected)