Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Mon Apr 03, 2006 10:16 am
Is there any way to export all the information from the Director to a CSV or some flat file.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Mon Apr 03, 2006 10:23 am
Use a shell script that uses the dsjob command, it first gets the list of jobs in a project and then loops through all elements in that list to put the log contents into a sequential file.
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Mon Apr 03, 2006 10:30 am
I dont want an automated way to do this as it will not be a part of the Job Process. I am looking for a one time manual process instead.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Mon Apr 03, 2006 10:47 am
The basic method remains the same, the command line to list a job's log requires a project and a job name. I would do a dsjob -ljobs for a project into a text file, then edit that file to execute the dsjob -log for each of the jobs found.
mauherga
Participant
Posts: 31 Joined: Thu Mar 02, 2006 9:47 am
Location: Mexico
Post
by mauherga » Tue Apr 04, 2006 12:21 pm
Hi DSguru2B,
Use the Print option in DS Director and select the "Print to File option" and save the information in a text file. Then use like you want.
I hope this can help you
maurik