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
Capture of Job Log Entries
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is a series of functions for capturing log information.
From the command line there are options to the dsjob command that perform similar functions, namely -logsum, -logdetail and -lognewest.
- DSGetLogSummary
DSGetNewestLogId
DSGetLogEntry
From the command line there are options to the dsjob command that perform similar functions, namely -logsum, -logdetail and -lognewest.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
where nnn is the job number obtained from the DS_JOBS table
Code: Select all
SELECT TIMESTAMP, SEVERITY, FULL.TEXT
FROM RT_LOGnnn
WHERE @ID NOT LIKE '//%'
ORDER BY @ID;
Code: Select all
SELECT NAME, CATEGORY, JOBNO
FROM DS_JOBS
WHERE NAME = 'MyJobName';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.