How to take backup of only few Categories of a project

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

Post Reply
reddy
Premium Member
Premium Member
Posts: 168
Joined: Tue Dec 07, 2004 12:54 pm

How to take backup of only few Categories of a project

Post by reddy »

Hello sir,

Currently i am taking backup of my windows server where my datastage installed (all projects) every week.
But in one of my project(HR) i have to take backup of 2 Categories every day.
Currently i am using windows batch file that contains following code:
*****************************************************
:: Supply values to paramters.
SET Host=156.80.214.58
::SET Host=dwetl-prod.bah.com
SET User=dsadmin
SET PW=adm1n
::SET BackupDir=c:\temp
SET BackupDir=d:\DSETLBackUp\Project
:: SET CompTog=%5
:: GOTO Syntax
:: *****************************************************
:: Hard-coded values. Dependent on each computer.

SET DsxCmd=C:\Progra~1\Ascential\DataStage7.5.1\dscmdexport.exe
::SET DsxJob=C:\Progra~1\Ascential\DataStage\dsjob.exe
SET TempFile=%BackupDir%\ProjList.txt
SET BadFile=%BackupDir%\BadProj.txt
SET GoodFile=%BackupDir%\GoodProj.txt
SET DSLog=BackupLog
:: SET CompScri=gzip --name -3
:: ******************************************************
Can you guys help me out how to take only few categories of one of my project.

Thanks in advance
Narasa
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

command line backup is project wide and cannot be done (as per my knowledge) on a category or job basis.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
reddy
Premium Member
Premium Member
Posts: 168
Joined: Tue Dec 07, 2004 12:54 pm

Post by reddy »

Thanks alot for quick response.
Any other thoughts please.
Thanks
Narasa
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Code: Select all

DSExport /U=%UserName% /P=%Password% /H=%Host% /JOB=JobName %Project% FileName 
Use the above option to export job wise. You can pass the list of jobs in a category as parameter.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

So we can do it on a per job basis. All this time i was under the impression that it could only be done project wide. Thanks for the insight Kumar. :)
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply