Page 2 of 2
Posted: Wed Mar 31, 2010 12:58 pm
by kduke
Here is the Driver script which could be scheduled easily.
Code: Select all
:: -----------------------------------------------------------------
:: DataStageExport1PerJobDriver.bat
:: -----------------------------------------------------------------
:: Host is server name
:: Project
:: User is username to use to attach to DataStage
:: Password is password to use to attach to DataStage
:: -----------------------------------------------------------------
call A_Edit_Me_First.bat
SET ExportDir=%BaseDir%\Backups
SET ProjectDir=%ExportDir%\%From_Project_Name%
:: Dwn_ExecTCL.exe -n -s%From_Host_Name% -u%From_Project_User% -p%From_Project_Pwd% UNLOCK READULOCK UV
DataStageExport1PerJob.bat %From_Host_Name% %From_Project_Name% %From_Project_User% %From_Project_Pwd%
Posted: Wed Mar 31, 2010 2:29 pm
by kduke
The call is to set the from and to variables on migrating jobs. It is the same as sourcing a shell script in UNIX with
It saves time in just editting this one thing.
Code: Select all
@echo off
:: -----------------------------------------------------------------
:: A_Edit_Me_First.bat
:: -----------------------------------------------------------------
:: Used to be called DataStageMigrateRequestor.bat
:: -----------------------------------------------------------------
::
:: This batch file needs to be edited each migration.
:: It is called be DataStageMigrate.bat
:: -----------------------------------------------------------------
:: -----------------------------------------------------------------
:: Server parameters
:: Dev to Test or Test to Prod ????????????
:: -----------------------------------------------------------------
SET From_Host_Name=dsdev
SET To_Host_Name=dstest
:: -----------------------------------------------------------------
:: Project parameters
:: -----------------------------------------------------------------
SET From_Project_Name=MyDevProject
SET From_Project_User=MyUser
SET From_Project_Pwd=MyPwd
SET To_Project_Name=MyTestProject
SET To_Project_User=MyUser
SET To_Project_Pwd=MyPwd
:: -----------------------------------------------------------------
:: ExportDir is the directory above the backed up project
:: -----------------------------------------------------------------
SET BaseDir=c:\DataStage\KimD
SET ProgDir=%BaseDir%\Scripts
:: -----------------------------------------------------------------
:: DsExportCmd Export command on client
:: DsImportCmd Import command on client
:: DsCompileCmd Compile command on client
:: -----------------------------------------------------------------
SET DsBaseDir=C:\Progra~1\Ascential\DataStage7.5.1
SET DsExportCmd=%DsBaseDir%\DsExport.exe
:: SET DsExportCmd=%DsBaseDir%\dscmdexport.exe
SET DsJobCmd=%DsBaseDir%\dsjob.exe
:: SET DsImportCmd=%DsBaseDir%\dscmdimport.exe
SET DsImportCmd=%DsBaseDir%\dsimport.exe
SET DsCompileCmd=%DsBaseDir%\dscc.exe
SET DsDesignerCmd=%DsBaseDir%\dsdesign.exe
:: -----------------------------------------------------------------
SET BackupDir=%BaseDir%\Backups
SET ExportDir=%BaseDir%\Backups
SET ProjectDir=%ExportDir%\%From_Project_Name%
:: -----------------------------------------------------------------
SET PerlBaseDir=C:\strawberry-perl\perl\bin
SET PerlStripDepsCmd=%PerlBaseDir%\perl.exe %BaseDir%\Scripts\StripDSJobDependencies.pl
SET JobList=JobList.txt
SET DsxList=DsxList.txt
:: -----------------------------------------------------------------