Scheduling job backup

Ahimsa · Post by **Ahimsa** » Wed Dec 20, 2006 9:28 pm

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!

chulett · Post by **chulett** » Wed Dec 20, 2006 9:33 pm

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.

Apotluri · Post by **Apotluri** » Wed Apr 30, 2008 5:43 pm

How to use it? any idea? just run the DataStageBackup.bat file??

jhmckeever · Post by **jhmckeever** » Wed Apr 30, 2008 6:41 pm

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.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 30, 2008 7:32 pm

manuel.gomez · Post by **manuel.gomez** » Mon Jun 16, 2008 9:04 am

so interesting!!!!