Job export utility

nirdesh2 · Post by **nirdesh2** » Sat May 09, 2009 4:44 am

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..

chulett · Post by **chulett** » Sat May 09, 2009 9:25 am

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.

nirdesh2 · Post by **nirdesh2** » Sat May 09, 2009 12:59 pm

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..

chulett · Post by **chulett** » Sat May 09, 2009 2:03 pm

dsjob -ljobs and dsexport are what you'd need.

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

Resist stupid requirements.

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

kduke · Post by **kduke** » Mon May 11, 2009 9:12 am

Amen brother.