monitor job

Shows runtime status information about running jobs, or jobs that have just finished.

Syntax

monitor job [job_name [comparison_name]]

Parameters

job_name – the name of the job with optional wildcards.
comparison_name – the name of the comparison with optional wildcards.
Note: You cannot use wildcard characters in job_name when you specify a comparison_name.

Examples

Example 1 – shows runtime information for all jobs:

monitor job
go

The returned result is:

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

Example 2 – shows the runtime information for the job named "j1":

monitor job j1
go

The 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%

Example 3 – shows the comparison information for the job named “j1”:

monitor job j1 cmp1
go

The returned result is:

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

Example 4 – shows the summary of comparison named "cmp_dp" with the combined progress:

monitor job job1 cmp_dp summary
go

The returned result set is:

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%