Page 1 of 1

How to Stop DataStage Job

Posted: Wed Aug 26, 2009 9:50 am
by aladap12
Hi All,

I tried to run before job subroutine ExecDos that kicks of .bat file which will do ftps process.(we can not use ftp stage)

I ran the datastage job, it is started but not finished,when I checked the Log it shows me like only 3 entries.

The job is still running since last two hours. when i try to stop from director
it not stopping the job,insted it say me like 'request send to server'

Could you suggest me how to stop this job .

Thanks
VKR

Posted: Wed Aug 26, 2009 9:59 am
by ArndW
The "stop" request is just that; the job needs to be checking for this flag to be set. Since it is executing within the before-job portion it won't get this signal. You will need to kill the process running the .bat file from outside of DataStage.

Thanks for the response

Posted: Wed Aug 26, 2009 11:29 am
by aladap12
ArndW wrote:The "stop" request is just that; the job needs to be checking for this flag to be set. Since it is executing within the before-job portion it won't get this signal. You will need to kill the process running the .bat file from outside of DataStage.
Hi,

We ran the .bat script out side the datastage,But it still show me in the director as that jobs in running state.
Is there any other way to stop that jobs..

Thanks
VKR

Posted: Wed Aug 26, 2009 1:25 pm
by Sainath.Srinivasan
That is mutually exclusive and completely unrelated.

Posted: Wed Aug 26, 2009 2:46 pm
by RAJEEV KATTA
Go to DataStage Director under the Job tab Click on cleanup process locate your job process id and kill it.Then go to the job tab again and click on clear status file which will reset your job status and would remove the present running status.

I did not get you

Posted: Thu Aug 27, 2009 7:43 am
by aladap12
Sainath.Srinivasan wrote:That is mutually exclusive and completely unrelated. ...
Excuse me! I did not get you

VKR

Posted: Thu Aug 27, 2009 7:48 am
by Sainath.Srinivasan
Running the ftp batch script outside DataStage will not in any way impact DataStage job status.

PS : Assuming that it does not call any datastage component from within.