DSXchange

Hi All,

I was interested to know if we can export log against all the jobs under a single project. I can manually save logs against individual jobs, just that it's not practical to export log of hundreds of jobs that way.

Regards,

Saad

Every job has its own log file, no matter what a loop thru a list of jobs is required to output all of the logs. Plus, you may only wish a limit on the output from the log. The best idea is to integrate with your job control processes an extraction of interesting log information at runtime followed by a prompt autopurge.

I can understand limiting the information out of log file, and to store only information which is more relevant (rows processed/rejected) but this requires a complete framework of storing metadata inside database alongside data itself.

My intention of asking this question was that what if metadata process hasn't been implemented and someone wanted to compare log against multiple days (but most logs are purged on some criteria). So this is only possible by storing the log file information in a separate text file and then referring to it when comparison is required.

Anyhow thank you for your response, I think I'll have to build a job to do the required task

Saad

Saad wrote:Anyhow thank you for your response, I think I'll have to build a job to do the required task

Check out http://www.duke-consulting.com/DataStage_Tips.htm and http://www.duke-consulting.com/Download ... 060704.zip. Even if you want to customize the code, this would be a good starting point.

Saad wrote:Anyhow thank you for your response, I think I'll have to build a job to do the required task

Check out http://www.duke-consulting.com/DataStage_Tips.htm and http://www.duke-consulting.com/Download ... 060704.zip. Even if you want to customize the code, this would be a good starting point.

Thanks for sharing this link

I do not have anything to export the whole log file of every job. There are several jobs which deal with read and extracting information from the log file.