DataStage Director Log for each job need in specified path

vinbhate · Post by **vinbhate** » Fri Nov 02, 2007 4:13 am

Hi All,
When we run or compile the job we see all the log in Datastage Director.Can we create this log in our path where we can maintain the log in my directory.OR once the log is created in Datastage Directory can we copy or automatically divert the log to create in specific path.

Actually i want to maintain the log of each job running in the specified path...Is that possible.Can anybody share there views on this.....

I tried writting routine and calling in after job sub routine...but routine doesnt work for me

.If somebody has tried please share your idea.

Reply will be appericated.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 02, 2007 4:35 am

The DataStage job log is a database table in the Repository - it is not a file. The best you can do is to dump the log into a file - you can not "maintain" the log in any sense.

vinbhate · Post by **vinbhate** » Fri Nov 02, 2007 4:40 am

Thanks for the reply Ray..
But can you give me some tips how to dump the log into file without manually copying and pasting into file.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 02, 2007 4:46 am

Director has a Print to File option.
You can create a "dump log to file" routine.
You can use dsjob to dump the log contents and redirect its output into a file of your choice.
There's three possibilities.

vinbhate · Post by **vinbhate** » Fri Nov 02, 2007 4:55 am

Yes this sound good to me.

sudheerkumar541 · Post by **sudheerkumar541** » Wed Jul 06, 2016 7:01 am

Hi you can try following command, and call after job subroutine through EXecSH

dsjob -logsum <projectname> <jobname> > sample.txt

ray.wurlod · Post by **ray.wurlod** » Wed Jul 06, 2016 4:57 pm

Thank you for contributing. The status of this thread suggests that it was resolved in 2007.