How to stop running job

[Kshitij Rawat]

Hi,
I am facing some problem in Directore.
I ran a job and its continuously running till now,i used the stop option in Director but it is still running.
I used kill command also to stop for result is remaining same .
Can any one tell me how to stop...??????

[chulett]

Since you've marked the post as such, what is your 'workaround'? So, you stopped it but your issue is the fact that the Director doesn't reflect that?

The kill command should be avoided as much as possible, especially a "kill -9". You need to know that when you kill a phantom process, the fact that it is no longer running may not get back to DataStage and thus Director will continue to say 'Running'. It's just a status, a flag, and so it will stay 'Running' forever until you intervene.

If you know for a fact that the job is not running, all processes have died / been killed, use the 'Clear Status File' to clear the running status on the job. It will change back to 'Compiled' and you can restart the job.

[Kshitij Rawat]

When i used Clear file status and run again i got yhis message


Can not get exclusive access to executable file for job PrepRoamexFile -job may be being monitored.

So who to run ..?

[chulett]

Either it is being monitored or it is in fact still running. You need to determine which.

[michaeld]

did you use the kill command from datastage or command line?

in Windows I use TASKKILL to kill the processes that are running under my userid and the job Aborts. Sometimes the job says that it is running when it is not. Just recompile it and the status will be reset.

You can also stop and restart DS services if you run out of options.

[rodre]

Is the PrepRoamexFile an external process like an .exe file?...

If it is....the problem is not with datastage. I had something similar happened to me lately and had to do with an outside program been corrupt....
E

[Kshitij Rawat]

It is not monitored but still running(may be hang) and when i ent stop request to server may be server not responed or the requrst not reached to server or may be some other processes hang..
I don't know what will be there but if i stop by clear file status and compile again i am getting this message:

Can not get exclusive access to executable file for job PrepRoamexFile -job may be being

You have any solution for above problem.
I think clean up all job in that user so that it can be compile again ,i know only this much... Need yiur suggesion
Thanks
Kshitij

[Krazykoolrohit]

Is this a development installation? then restart the datastage server.

If the above doesnt work, restart the unix box.

PS: this should be your last option...

[Kshitij Rawat]

Thanks for your co-opration .I think this will be the better option.will do
Thanks again