Page 1 of 1
Scheduling job backup
Posted: Wed Dec 20, 2006 9:28 pm
by Ahimsa
Is there a way to SCHEDULE backup of job designs and routines.
Currently, I go to DataStage Manager and select job to take the backup.
So instead of doing this manually everyday, is there a way to schedule a backup ?
Many thanks!
Posted: Wed Dec 20, 2006 9:33 pm
by chulett
Go to
Kim Duke's website and download the backup script you'll find in his Tips & Tricks section. It will export and date-stamp every Project on the server you attach to automagically - and you can schedule it.
![Wink :wink:](./images/smilies/icon_wink.gif)
Posted: Wed Apr 30, 2008 5:43 pm
by Apotluri
How to use it? any idea? just run the DataStageBackup.bat file??
Posted: Wed Apr 30, 2008 6:41 pm
by jhmckeever
There's nothing destructive about the script, so go ahead and try it - You'll get a helpful usage message:
Code: Select all
DataStage Automated Backup Routine
Based on design by Manoli Krinos
Modified by M Ruland to allow iteration through a
complete server set of projects
Also Modified by T.J. Griesenbrock to utilize command
line options.
Usage: DataStageBackup SERVER USERNAME PASSWORD BASE_DIR PROJECT_LIST
SERVER - Hostname
USERNAME - Username to use on SERVER.
PASSWORD - Associated password for USERNAME on SERVER.
BASE_DIR - Scripts, Backup directory below this. MUST be a pre-existing directory.
PROJECT_LIST - MUST be a pre-existing directory.
You can schedule this (Control Panel -> Scheduled Tasks) to run as often as you like, but make sure it's run at a time when it's unlikely that a user will be connected to the project as any locked jobs will not be exported.
For example, on my current project, I could easily schedule the backup to begin at 9am with no adverse consequences on the development team!
J.
Posted: Wed Apr 30, 2008 7:32 pm
by ray.wurlod
Posted: Mon Jun 16, 2008 9:04 am
by manuel.gomez
so interesting!!!!