To get the logs for all the jobs

prem84 · Post by **prem84** » Thu Sep 08, 2011 5:27 am

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

chulett · Post by **chulett** » Thu Sep 08, 2011 6:56 am

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.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 08, 2011 4:39 pm

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

kduke · Post by **kduke** » Wed Sep 14, 2011 5:10 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 15, 2011 1:43 am

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.