Can we export joblog to a file
Moderators: chulett, rschirm, roy
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Can we export joblog to a file
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
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
Nobody is perfect, ....I'm Nobody
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
viewtopic.php?t=90083
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Can we export joblog to a file
if u r using DS8.1 or 8.0.1 ..go to the information analyzer and import ur log file...thats pretty easy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Can we export joblog to a file
DSXchange is NOT a mobile telephone!!! Please DO NOT use SMS-style abbreviations.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
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.