Exporting jobs through Commad prompt

[AmeyJoshi14]

Hi,
We want to export four jobs and want to store it in one.dsx file, is it possible with command prompt?
We do not want to use Datastage Manger for the same..
We have searched in "dsjob" but there is only import option.no export option is present..
Can anybody help us out?
Thanks In Advance!!

[ray.wurlod]

You could investigate dsexport.exe command.

There is nothing on the server.

[priyadarshikunal]

you can use this command its there in 8x but dont know its there in 7x or not

Code: Select all

cd path of dscmdexport.exe

dscmdexport /D=ServerIP:9080 /H=ServerIP:31801 /U=UserName /P=password ServerName/ProjectName ProjectExport.dsx

you can put it in a batch file and then schedule it

if you want only few jobs from a project then search for some options of dscmdexport

regards

[AmeyJoshi14]

Thanks

But where can find this ".exe "

[chulett]

Either by searching or by looking wherever you installed the DataStage client on your PC. Typically C:\Program Files\Ascential\DataStage...

[etlbets]

I have written a BAT script that takes a list of jobs and exports them one at a time into a a single dsx on your PC is this what you are looking for.

[ray.wurlod]

As per the details in the above post i have searched for dsexport and dscmdexport in '/tools/Ascential/DataStage', but any of the "export" commands are not present in the above path.
Can anybody please tell me why this commands are not present in our environment?

UNIX pathnames? These executables are on the client machine, not on the server machine.

[AmeyJoshi14]

I have written a BAT script that takes a list of jobs and exports them one at a time into a a single dsx on your PC is this what you are looking for.

Hi,
Yes can you please provide me the script ,so that we can implement the same :D
Thanks in Advance!