Hi ,
Is there a way to get logs for all the jobs in a datastage project.
To get the logs for all the jobs
Moderators: chulett, rschirm, roy
Yes, several. Let's start with the standard response: search the forums for ETLStats, a package that Kim Duke gives away from his website. You'll also find other discussions on rolling your own using either the DSGet* functions or their dsjob equivalents, depending on where you want to implement this - from inside a Server job / job control code or scripted from the command line.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Be aware that, whichever approach you use, this is a non-trivial exercise. The job log for each job is in a separate database table (assuming you're using the recommended RTLogging).
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:
If you follow best practice logs ARE stored in RT_LOGnnn files in version 8. IBM realized that storing them in the common metadata repository imposed to great an overhead, and now provide RTLogging and ORLogging settings (per project) and recommend that you use RTLogging - that is, logging in local project repository.
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.