show report

Generates and shows the report file path of the job with a specified history ID.

Syntax

show report job_name history_id 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.
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
```
Note: Executing show history generates text and XML reports, if they have not already been generated, before showing the output. The more the differences the longer it takes show history to generate the reports, which causes a delay in showing the results.

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
…