Hi All,
We are running our daily incremental in DW ,and we are taking the start time and end time of all the jobs (1026 jobs) manually.We are trying to automate this process, but we dont know where the logs are captured for all the jobs in datastage.
If we are running the sequencer,there might be some 30 jobs ,and there will be a log file must be created for the sequencer.
Please let me know the location of the log file captured.
Log files
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 10
- Joined: Thu May 24, 2007 12:34 am
- Location: India
Log files
Thanks,
Mohana Krishnan
Mohana Krishnan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is no such thing as a log file - each job log in DataStage is a separate table in the Repository database. The name of the table is RT_LOG followed by the job number. The job number is mapped to the job name in the DS_JOBS table.
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.