Page 1 of 1

Job export utility

Posted: Sat May 09, 2009 4:44 am
by nirdesh2
We have 100 jobs in dev environment and we have to move all the job in test environment. We have to export single job at a time. we cant take the export of full project at a time(This is the requirement). Is there any command or utility that can be used to take export of all the jobs(one job at a time) from a project..

Posted: Sat May 09, 2009 9:25 am
by chulett
All the jobs one at a time? You'll need to script that, extract a list of job names and then iterate through that list, exporting each one.

Posted: Sat May 09, 2009 12:59 pm
by nirdesh2
I am looking for that script...If some one can provide some idea or sample script then it will be very helpfull.Can someone provide necessary ds command that needs to be used in script..

Posted: Sat May 09, 2009 2:03 pm
by chulett
dsjob -ljobs and dsexport are what you'd need.

Posted: Sun May 10, 2009 4:54 pm
by ray.wurlod
Resist stupid requirements.

Make one export and make use of DataStage's ability to perform partial import of the contents of the export file.

Posted: Mon May 11, 2009 9:12 am
by kduke
Amen brother.