show report

Syntax

show report job_name history_id latest report type

Parameters

• job_name – the name of the job for which to show the report.
• history_id – the job history sequence ID of the report to be shown.
• latest – the job history with the highest sequence ID to be shown in the report.
• report_type – the type of report to fetch (Text or XML).

Examples

• Example 1 – shows the report file path for “job6” with history ID 29:

  show report job6 29
  go

  The returned result is:

  REPORT TYPE SERVER PATH
  ----------- ----------------------------------------------------------------------------
  TEXT        /Sybase/DA-15_5/server/myserver/data/job6/2012-11-06/11.52.56.458/report.txt
  XML         /Sybase/DA-15_5/server/myserver/data/job6/2012-11-06/11.52.56.458/report.xml
  

• Example 2 – shows the text report for the job6 with history ID 29:

  show report job6 29 TEXT
  go

  The returned result is:

  CONTENT
  -------------------------------------
  Report generated: 2012-11-07 12:34:01
  File encoding: UTF-8
  Job submitted: 2012-11-06 11:52:56
  Job completed: 2012-11-06 11:53:02
  Differences detected: 9
  …

• Example 3 – Shows the text report using the latest keyword for the job6:

  show report job6 latest TEXT

  The result displayed here shows only the first row of the report:

  CONTENT
   ---------------------------------------
   Report generated: 2014-01-10 12:32:01
   File encoding: utf8
   Job submitted: 2013-10-09 15:06:05
   Job completed: 2013-10-09 15:06:43
   Differences detected: 3
  
  job job6
     options
       MAX_CONCURRENT_COMPARISONS = 5
     comparison c
       COMPARESET = compareset5
   ...