Page 1 of 1

Job running in a infinite loop

Posted: Wed Mar 19, 2008 3:51 am
by MOHAMMAD.ISSAQ
I have a job that's running continuosly even if i try to stop it through director it's not stopping.
Can anyone tell me how to get the process id of the particular job and how to kill the job in Unix?

Please help me out..

Posted: Wed Mar 19, 2008 4:06 am
by ray.wurlod
It's almost definitely NOT an infinite loop - it's much more likely to be a hang (wait) of some kind.

What is the job doing? There are many reasons this behaviour may obtain. For example there may be an active session in a database and DataStage is waiting for this to complete. (You can kill the session in the database, which will send an error back to DataStage but will then permit the job to stop.)

Posted: Wed Mar 19, 2008 4:15 am
by MOHAMMAD.ISSAQ
The job is under "running" status for the past 2 hrs.
The "clear status file" is not active for this job and i'm not able to view the job in "Cleanup Resources" option.

What might be the reason?

Posted: Wed Mar 19, 2008 4:17 am
by ArndW
Perhaps it is no longer actually running, but the status still might indicate that. Can you re-compile the job?

Posted: Wed Mar 19, 2008 4:24 am
by MOHAMMAD.ISSAQ
Yes i'm able to compile the jobs.
It's just showing the status as "running".


Thanks for the help..