job never ends

kirankota79 · Post by **kirankota79** » Fri May 23, 2008 6:44 am

I am running a datastage job against an oracle table which contains 9 rows.
Due to some reasons the job is never finishing and still showing as RUNNING in the director. Can you please let me know how to kill this job? This is on windows 2003 server

ArndW · Post by **ArndW** » Fri May 23, 2008 6:46 am

Have you tried "stop job" from the director? If this hasn't helped, then the job is in a waiting state where it isn't able to respond to stop requests, which would be in the database in this case. Can you have the Oracle DBA check the locks and clear them, that will most likely also cause your hanging job to stop.

chulett · Post by **chulett** » Fri May 23, 2008 7:12 am

Or have the DBA kill the SID. That's usually the best way to clear any locks.