Backup Of DS Jobs

paranoid · Post by **paranoid** » Wed Aug 05, 2009 8:26 am

Hi,

We are planning to backup all the datastage jobs on a regular basis.
Is there any way of automating that process?

I am aware of the manual backup of the Jobs but not the automated technique.

Version : DS 7.5

Please advise.

Thanks

Sue

chulett · Post by **chulett** » Wed Aug 05, 2009 8:43 am

Go here and then look for mention of "DataStageBackup.bat" for a batch file you can run to do this. Or you can roll your own, of course, using dscmdexport.exe if you like.

DS_SUPPORT · Post by **DS_SUPPORT** » Wed Aug 05, 2009 8:45 am

Check Kim Duke's Website. He is having a Batch file, which will backup all the projects in a server.

paranoid · Post by **paranoid** » Wed Aug 05, 2009 9:17 am

Thank-you very much!! I have just gone through that script and analysing where to hard-code the parameters.

Thanks

Sue

paranoid · Post by **paranoid** » Wed Aug 05, 2009 10:14 am

dscmdexport.exe /H=Servername /U=Username /P=Password Projectname Scripts\backup.dsx

This solved my purpose..

Thanks for guiding me through this process.

Sue

kduke · Post by **kduke** » Wed Aug 05, 2009 4:41 pm

The backup script does way more than this. It does one per project per server if you like. It can easily separate these by the naming convention it uses. So you can archive these files.

paranoid · Post by **paranoid** » Thu Aug 06, 2009 7:08 am

Thats awesome duke!!

Is it possible to backup a separate folder from a project instead of all folders at a time?

Please advise.

Thanks

Sue

kduke · Post by **kduke** » Thu Aug 06, 2009 7:21 am

You would need to modify the script. The name would get longer but I think it is possible.

paranoid · Post by **paranoid** » Thu Aug 06, 2009 7:25 am

Thanks duke!!

Could you provide me with the new script, if possible?

Thanks

sue

kduke · Post by **kduke** » Thu Aug 06, 2009 3:18 pm

You need to modify it. Not me. I give this stuff away. I don't do the modifications unless I get paid.