Job is hanging!!
Posted: Tue May 15, 2007 5:04 pm
Hello,
When I try to run some of my DS jobs it just hangs and does nothing. eventually I had to kill them from the server. This happens to all jobs that tries to access one particular database. Every other job runs fine. I am able to access that database through TOAD. I am also able to view data thru the Oracle Enterprise Stage, but when I actually try to run the job ithangs.
Could someone please direct me in identifying a fix for this issue??
Thanks.
When I try to run some of my DS jobs it just hangs and does nothing. eventually I had to kill them from the server. This happens to all jobs that tries to access one particular database. Every other job runs fine. I am able to access that database through TOAD. I am also able to view data thru the Oracle Enterprise Stage, but when I actually try to run the job ithangs.
Could someone please direct me in identifying a fix for this issue??
Thanks.