Shows the history, including the report file and reconciliation file path, for a single job.
show history
[job_name
[ {history_id | latest
[ {comparison_name | summary }]
[where where_argument]
] ]
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 |
show history job2 go
HISTORY ID SUBMIT TIME FINISH TIME ---------- ----------------------- ---------------------- 12 2010-10-13 14:38:11.783 2010-10-13 14:38:19.41
show history job2 12 go
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
show history go JOB NAME HISTORIES ----------- --------- custTables 3 stockTables 12 test1 2 (0 rows affected)
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)
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
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)
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)