Job running in a infinite loop

MOHAMMAD.ISSAQ · Post by **MOHAMMAD.ISSAQ** » Wed Mar 19, 2008 3:51 am

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..

ray.wurlod · Post by **ray.wurlod** » Wed Mar 19, 2008 4:06 am

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.)

MOHAMMAD.ISSAQ · Post by **MOHAMMAD.ISSAQ** » Wed Mar 19, 2008 4:15 am

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?

ArndW · Post by **ArndW** » Wed Mar 19, 2008 4:17 am

Perhaps it is no longer actually running, but the status still might indicate that. Can you re-compile the job?

MOHAMMAD.ISSAQ · Post by **MOHAMMAD.ISSAQ** » Wed Mar 19, 2008 4:24 am

Yes i'm able to compile the jobs.
It's just showing the status as "running".

Thanks for the help..