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:

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
:lol:

Posted: Mon Jun 16, 2008 9:04 am
by manuel.gomez
so interesting!!!!