Shows runtime status information about running jobs, or jobs that have just finished.
monitor job [job_name [comparison_name]]
monitor job go
NAME TYPE STATUS SUBMIT TIME FINISH TIME ERROR ---- --------------- ------- ------------ ----------- -------- job2 ROW_COMPARE_JOB RUNNING 2010-10-18 09:14:53.358 job6 ROW_COMPARE_JOB RUNNING 2010-10-18 09:14:57.093
monitor job j1 goThe returned result is:
COMPARISON PART STATUS SUBMIT TIME END TIME RUN PROGRESS ---------- ---- -------- ------------------- ------------------- --- -------- cmp1 0 FINISHED 2011-10-10 17:16:13 2011-10-10 17:16:33 6 100% cmp2 0 FINISHED 2011-10-10 17:16:13 2011-10-10 17:16:32 6 100%
monitor job j1 cmp1 go
COMPARISON PART SUBMIT TIME END TIME ---------- ---- ------------------- ------------------- cmp1 0 2011-10-10 17:16:13 2011-10-10 17:16:33 0 2011-10-10 17:16:13 2011-10-10 17:16:33 RUN PHASE PART TYPE SUMMARY START TIME --- --------------------- ---- ---- ---------------------- ----------- 1 COMPARE_ALL 0 S conn1/dbo.da1_10m 2011-10-10 17:16:14 T conn2/dbo.da1_10m 2011-10-10 17:16:14 0 S conn1/dbo.da1_10m 2011-10-10 17:16:14 T conn2/dbo.da1_10m 2011-10-10 17:16:14 2 RECHECK_DIFFERENCES 0 T conn2/dbo.da1_10m 2011-10-10 17:16:14 0 T conn2/dbo.da1_10m 2011-10-10 17:16:14 3 RECHECK_DIFFERENCES 0 T conn2/dbo.da1_10m 2011-10-10 17:16:14 0 T conn2/dbo.da1_10m 2011-10-10 17:16:14 4 RECHECK_DIFFERENCES 0 T conn2/dbo.da1_10m 2011-10-10 17:16:14 0 T conn2/dbo.da1_10m 2011-10-10 17:16:14 5 VERIFY_DIFFERENCES 0 S conn1/dbo.da1_10m 2011-10-10 17:16:14 T conn2/dbo.da1_10m 2011-10-10 17:16:14 0 S conn1/dbo.da1_10m 2011-10-10 17:16:14 T conn2/dbo.da1_10m 2011-10-10 17:16:14 6 CREATE_RECONCILIATION_SCRIPT ALL T conn2/dbo.da1_10m 2011-10-10 17:16:33
monitor job job1 cmp_dp summary go
COMPARISON PART SUBMIT TIME END TIME ---------- ---- ------------------- ------------------- cmp_dp 0 2012-10-02 11:18:44 RUN PHASE PART TYPE SUMMARY START TIME END TIME COUNT READ M O I R PROGRESS ESTIMATE END ERROR --- ----------- ---- ---- -------------------- ------------------- ------------------- ------- ------ -- - ----- - -------- ------------ ----- 1 COMPARE_ALL ALL S soka2ase/dbo.da1_10m 2012-10-02 11:18:50 1000000 586533 62.9% T soka3ase/dbo.da1_10m 2012-10-02 11:18:50 999990 586521 10 0 10015 62.9%