Can we export joblog to a file

DSRajesh · Post by **DSRajesh** » Sat Jun 23, 2007 8:50 pm

Its simple to create the job

chulett · Post by **chulett** » Sat Jun 23, 2007 9:42 pm

If you look, you'll notice the jobs are not producing 'excel' files but rather simple 'csv' or comma separated value files. They can then be opened by Excel and (if desired) saved back as an xls file.

Take all the defaults in the Sequential File stage and you'll get a csv file, but you'll probably want to include column name headers as well.

DSRajesh · Post by **DSRajesh** » Sun Jun 24, 2007 2:36 am

chulett · Post by **chulett** » Sun Jun 24, 2007 7:17 am

There's a wealth of information here on getting information out of job logs, all you need to do is search for it. Check the online help for the various DSGetLog related functions, if you want to write a routine, or the Command Line Interface section in the Server Job Developer's Guide if you want to tackle this from a scripted standpoint.

Jeawin has offered to send their jobs to anyone for the asking, why not ask them? Or download ETLStats from Kim Duke's website. Not only will you get the full ETLStats goodness, but there will be lots of examples on how to farm the crap out of your job logs. And I mean 'crap' in a good sense.

DSRajesh · Post by **DSRajesh** » Mon Jun 25, 2007 10:54 am

priyadarshikunal · Post by **priyadarshikunal** » Mon Jun 25, 2007 11:59 pm

hi Jeawin,

can u send me your jobs to priyadarshikunal@gmail.com

thanks in advance

bnet2 · Post by **bnet2** » Sun Mar 01, 2009 6:24 am

hi jeawin
I desperately sought a routine that allows you to set the log of the director,
I came across your example that I draw my attention,
I wanted to know me if you can share your solution
Can u send me your jobs to bnet_2@yahoo.fr

Thank you in advance

chulett · Post by **chulett** » Sun Mar 01, 2009 8:52 am

If you checked, you'd find they haven't posted here in a while so good luck with that. Did you read the entire thread? Ray noted a post with everything anyone would need to get them going, give it a shot:

viewtopic.php?t=90083

mandyli · Post by **mandyli** » Thu May 07, 2009 4:45 pm

Hi

I am also facing same kind of issue.

Can you please provide code for this?

Thanks
Man

ray.wurlod · Post by **ray.wurlod** » Thu May 07, 2009 5:06 pm

Did you even bother to look at the link Craig posted, or do you just want everything handed to you on a silver platter?

pandujoy · Post by **pandujoy** » Fri May 08, 2009 2:56 pm

if u r using DS8.1 or 8.0.1 ..go to the information analyzer and import ur log file...thats pretty easy

ray.wurlod · Post by **ray.wurlod** » Sun May 10, 2009 4:36 pm

pandujoy wrote:if u r using DS8.1 or 8.0.1 ..go to the information analyzer and import ur log file...thats pretty easy

DSXchange is NOT a mobile telephone!!! Please DO NOT use SMS-style abbreviations.

DSXchange

Can we export joblog to a file

Can we export joblog to a file

Re: Can we export joblog to a file

Re: Can we export joblog to a file