show report

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

Syntax

show report job_name historyid

Parameters

job_name – the name of the job for which to show the report.
historyid – the job history sequence ID of the report to be shown.

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         C:\Sybase\DA-15_5\server\instance\data\job6\
2010-10-15\14.04.03\report.txt
XML          C:\Sybase\DA-15_5\server\instance\data\job6\
2010-10-15\14.04.03\report.xml
(0 row affected)