Job Logs

bobthebuilder · Post by **bobthebuilder** » Fri Sep 16, 2005 12:49 pm

All,

Is there any way the individual job logs created for every job be sent a named file on some server.

-- Bob

ray.wurlod · Post by **ray.wurlod** » Fri Sep 16, 2005 4:30 pm

Yes.

But it's a DIY (do it yourself) solution. You need to extract events from the log tables and direct them to the file(s) in question.

An ideal mechanism would be a DataStage job! :D

elavenil · Post by **elavenil** » Fri Sep 16, 2005 11:36 pm

Hi,

Search for DSGetLogEntry & DSGetLogSummary routines in DS help and Log of a job can be obtained using these functions.

HTWH.

Regards
Saravanan

chinek · Post by **chinek** » Sun Sep 18, 2005 5:54 pm

We use dsjob and a unix script to parse the log files. Using something like an awk script or others will allow you to create delimeted files which can be loaded into the database. Lke Ray said it's all DIY.

Nick

trokosz · Post by **trokosz** » Mon Sep 19, 2005 10:25 pm

As Ray indicated its a do it yourself or extract the log and send to a flat file that can be FTP'd or emailed.....Just a point that if your into using invocation ids ten its tricky to have them appear in the extracted log....search for the custom solution.....