Page 1 of 1

Backup Of DS Jobs

Posted: Wed Aug 05, 2009 8:26 am
by paranoid
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

Posted: Wed Aug 05, 2009 8:43 am
by chulett
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.

Posted: Wed Aug 05, 2009 8:45 am
by DS_SUPPORT
Check Kim Duke's Website. He is having a Batch file, which will backup all the projects in a server.

Posted: Wed Aug 05, 2009 9:17 am
by paranoid
Thank-you very much!! I have just gone through that script and analysing where to hard-code the parameters.

Thanks

Sue

Posted: Wed Aug 05, 2009 10:14 am
by paranoid
dscmdexport.exe /H=Servername /U=Username /P=Password Projectname Scripts\backup.dsx

This solved my purpose..

Thanks for guiding me through this process.

Sue

Posted: Wed Aug 05, 2009 4:41 pm
by kduke
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.

Posted: Thu Aug 06, 2009 7:08 am
by paranoid
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

Posted: Thu Aug 06, 2009 7:21 am
by kduke
You would need to modify the script. The name would get longer but I think it is possible.

Posted: Thu Aug 06, 2009 7:25 am
by paranoid
Thanks duke!!

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


Thanks

sue

Posted: Thu Aug 06, 2009 3:18 pm
by kduke
You need to modify it. Not me. I give this stuff away. I don't do the modifications unless I get paid.