Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
paranoid
Premium Member
Posts: 185 Joined: Tue May 29, 2007 5:50 am
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
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
DS_SUPPORT
Premium Member
Posts: 232 Joined: Fri Aug 04, 2006 1:20 am
Location: Bangalore
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
Premium Member
Posts: 185 Joined: Tue May 29, 2007 5:50 am
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
Premium Member
Posts: 185 Joined: Tue May 29, 2007 5:50 am
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
Charter Member
Posts: 5227 Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:
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.
Mamu Kim
paranoid
Premium Member
Posts: 185 Joined: Tue May 29, 2007 5:50 am
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
Charter Member
Posts: 5227 Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:
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.
Mamu Kim
paranoid
Premium Member
Posts: 185 Joined: Tue May 29, 2007 5:50 am
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
Charter Member
Posts: 5227 Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:
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.
Mamu Kim