server routine to get the datastage job log information

oracle · Post by **oracle** » Sat Oct 08, 2011 4:54 am

Hi All,

I have developed one sequence having 3 jobs .Here my requirement is if any one of the job fails then i need to capture the oborted job log information into file.
I need a server routine to capture the datastage job log information into text file.

Kindly guide me ?

Regards
vara

ray.wurlod · Post by **ray.wurlod** » Sat Oct 08, 2011 3:33 pm

The server routine would need to:

attach to the job (DSAttachJob)

open the text file (OpenSeq or OpenSequentialFile)

read through its log (DSGetLogSummary, DSGetNewestLogId, DSGetLogDetail)

write required information to text file (WriteSeq)

close text file (CloseSeq)

detach from job (DSDetachJob)

handle any errors that may have occurred during the above

pandeesh · Post by **pandeesh** » Sat Oct 08, 2011 11:49 pm

The routine what you require is already there.
Please do an exact search so that you can get it.
I have posted a routine which captures log info and mail it.
The log will appear in body of the mail.
You can modify as per your requirement.

leandrohmvieira · Post by **leandrohmvieira** » Wed Jan 20, 2016 10:39 am

Hello pandeesh, can you link us here? I couldn't find it

thanks in advance

chulett · Post by **chulett** » Wed Jan 20, 2016 10:44 am

I'm assuming it is buried in here somewhere since he pointed other people to it in the past. I'm sure there's better examples, but there you go.