Page 1 of 1
is there any command to export all jobs log to a text file i
Posted: Wed Nov 28, 2007 11:42 pm
by major
Hi,
is there any command to export all jobs log to a text file in windows environment?
Posted: Thu Nov 29, 2007 1:32 am
by ray.wurlod
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.
Posted: Mon Dec 03, 2007 9:56 am
by WoMaWil
If your Server is Windows you can write a batch file for to do it. Look into the manual after the dsjob-command.
Posted: Tue Dec 04, 2007 1:14 pm
by major
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