Capture of Job Log Entries

[avenki77]

I want to capture all the job log entries into a text file. How can I do it from within a Server Job? Are there some builtin routines or DS functions available to accomplish this task ?

Thanks in advance
Venkatesh

[ray.wurlod]

There is a series of functions for capturing log information.

• DSGetLogSummary
  DSGetNewestLogId
  DSGetLogEntry

You can use these within DataStage BASIC code, for example in a job control routine or in a before/after subroutine. Statements for working with text files include OpenSeq, WeofSeq, WriteSeq , Seek and CloseSeq.

From the command line there are options to the dsjob command that perform similar functions, namely -logsum, -logdetail and -lognewest.

[ray.wurlod]

Since a job log is a table in the Repository, you can also use SQL, executed within the DataStage environment on the server or through the Administrator client Command window.

Code: Select all

SELECT TIMESTAMP, SEVERITY, FULL.TEXT 
FROM RT_LOGnnn
WHERE @ID NOT LIKE '//%'
ORDER BY @ID;

where nnn is the job number obtained from the DS_JOBS table

Code: Select all

SELECT NAME, CATEGORY, JOBNO
FROM DS_JOBS
WHERE NAME = 'MyJobName';