Job running continously

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

Job running continously

Post by reddy »

Sir,

One of my batch job which is taking backup of all jobs in a project is running continously from last 24 hours.I tried abort this job also.
Even though this job is running.

Can you please help me out on how to stop this.

Thanks in advance
Narasa
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

How is this job taking a "backup"? Perhaps this job is waiting for some resource to be released and therefore looks like it is hanging. Also, how did you kill the job?
narasa
Participant
Posts: 2
Joined: Tue Nov 30, 2004 11:48 am

Post by narasa »

Thanks for quick response.

i am using datastage supplied backup.bat script:

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

I created job sequence using this batch script.

Can you please help me on how to kill this process.

Thanks
Narasa
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Only run it when nothing is open for editing, so that you don't hang up on locks in the Repository database.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply