Log Path to see the Job LOG - not thru Director!!!

Titto · Post by **Titto** » Wed Nov 30, 2005 9:03 am

Hi,

My Director is not able to show a particular job log , may be it is too big to load.
Is there a way to look at the Job Log in Unix? , not thru Director.
if so where do i look for job log in Ascential path?

Thanks

ArndW · Post by **ArndW** » Wed Nov 30, 2005 9:28 am

The job log is in a DataStage table and is not a sequential file. You can use the UNIX command "dsjob -log <project> <job>" to get this information listed to standard output and could redirect that to a text file.

Addendum - I should have read the whole post before replying, after seeing Rays's response I realize that I answered a question that really wasn't asked.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 30, 2005 3:48 pm

I suspect you are just being impatient. To retrieve the job log, a request of the form SELECT * FROM RT_LOGnnn WHERE ... ORDER BY 1 must be issued against the Repository database. If there are many entries in the log table, sorting the report will take quite some time. No rows can be returned until the sorting has been completed. That's why we endeavour to keep logs small.

nivas · Post by **nivas** » Wed May 28, 2008 8:11 am

ArndW wrote:The job log is in a DataStage table and is not a sequential file. You can use the UNIX command "dsjob -log <project> <job>" to get this information listed to standard output and could redi ...

How can we get the log info with Windows as OS. I am trying to view the log other than Director.

thanks
Nivas

ArndW · Post by **ArndW** » Wed May 28, 2008 8:13 am

The "dsjob" command is the same on Windows and UNIX. It can be called from either the server or the client.

chulett · Post by **chulett** » Wed May 28, 2008 8:14 am

Same answer for Windows.

nivas · Post by **nivas** » Wed May 28, 2008 8:17 am

chulett wrote:Same answer for Windows.

I am trying to find how do I read from output stream to a file in DOS. The following I am getting.

C:\ASCENT~1\DATAST~1\Engine\bin>dsjob -log HSNOUB92Warehouse BatchHSNOCHCWarehou
se1
Enter message text, terminating with Ctrl-d
Nivas^D

Message read.

After this How do read the message or log to a file ?

thanks
Nivas

ArndW · Post by **ArndW** » Wed May 28, 2008 8:21 am

"dsjob -log" inserts a record into the log, you are looking for "dsjob -logsum"

nivas · Post by **nivas** » Wed May 28, 2008 8:27 am

ArndW wrote:"dsjob -log" inserts a record into the log, you are looking for "dsjob -logsum" ...

Excellent.

Thanks
Nivas

chulett · Post by **chulett** » Wed May 28, 2008 8:33 am

You'll need to redirect the output for the 'to a file' part, which means adding " > filenname" or perhaps " >> filename" to the end of the command.

nivas · Post by **nivas** » Wed May 28, 2008 10:38 am

Thank you very much for all.
Nivas

ray.wurlod · Post by **ray.wurlod** » Wed May 28, 2008 1:51 pm

If that's a solution please mark the thread as Resolved.