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 to be shown.
comparison_name – the name of the comparison to be shown.

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 comparison information for job “j1” :

monitor job j1 c1
go

The returned result is:

COMPARISON SUBMIT TIME         END TIME
---------- ------------------- -------------------
 c1         2011-03-01 16:49:34 2011-03-01 16:49:47

(0 rows affected)

 RUN PHASE                TYPE SUMMARY        START TIME          END TIME            
 --- -------------------- ---- -------------- ------------------- ------------------- 
 COUNT READ  M    O I R   PROGRESS ESTIMATE END ERROR
 ----- ---- ---- - - --   -------- ------------ -----
 1   COMPARE_ALL          S    c1/dbo.person  2011-03-01 16:49:34 2011-03-01 16:49:34 
 3072  3072               100%
                          T    c1/dbo.person2 2011-03-01 16:49:34 2011-03-01 16:49:34 
 1109  1109 1963 0 0      100%
                          T2   c1/dbo.person3 2011-03-01 16:49:34 2011-03-01 16:49:34 
 1109  1109 1963 0 0      100%
 2   RECHECK_DIFFERENCES  T                   2011-03-01 16:49:45 2011-03-01 16:49:45       
       0    1963 0 0      100%
                          T2                  2011-03-01 16:49:45 2011-03-01 16:49:45       
       0    1963 0 0      100%
 3   VERIFY_DIFFERENCES   S                   2011-03-01 16:49:45 2011-03-01 16:49:46       
      1963               100%
                          T                   2011-03-01 16:49:45 2011-03-01 16:49:46       
      0    1963 0 0      100%
                          T2                  2011-03-01 16:49:45 2011-03-01 16:49:46      
      0    1963 0 0      100%
 4   APPLY_RECONCILIATION T                   2011-03-01 16:49:46 2011-03-01 16:49:47 
                    1963 100%
                          T2                  2011-03-01 16:49:46 2011-03-01 16:49:47    
                    1963  100%