DSXchange

Hi ,
Is there a way to get logs for all the jobs in a datastage project.

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.

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).

Logs are not stored in RT_LOG files in version 8. They are in a table. You can use SQL if you figure out what the table name is.

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.