is there any command to export all jobs log to a text file i

major · Post by **major** » Wed Nov 28, 2007 11:42 pm

Hi,

is there any command to export all jobs log to a text file in windows environment?

ray.wurlod · Post by **ray.wurlod** » Thu Nov 29, 2007 1:32 am

No. Each job log is a separate database table in the Repository.

I guess you *could* theoretically create a UNION ALL of all those tables, but I suspect you would hit some command line length limit for a sufficiently large number of jobs.

WoMaWil · Post by **WoMaWil** » Mon Dec 03, 2007 9:56 am

If your Server is Windows you can write a batch file for to do it. Look into the manual after the dsjob-command.

major · Post by **major** » Tue Dec 04, 2007 1:14 pm

WoMaWil wrote:If your Server is Windows you can write a batch file for to do it. Look into the manual after the dsjob-command.

hi,
thanks for ur response, i am using windows sever,but i am new to datastage , can u please elaborate more on this?
thanks in advance