Locked jobs

rajsimha123 · Post by **rajsimha123** » Wed Jun 02, 2004 2:16 am

What needs to be done if a job gets locked ?

richdhan · Post by **richdhan** » Wed Jun 02, 2004 2:59 am

Hi,

Pls search the forum. This has already been discussed lot many times.
You can use the cleanup resources option in the Director to unlock a job. For more information on this do a search.You would get extensive information.

--Rich

ray.wurlod · Post by **ray.wurlod** » Wed Jun 02, 2004 4:39 am

Please be more specific. Do you mean that the job design gets locked (this job is in use by another process)? Or do you mean locked in that it appears to be running but not processing any rows? Or something else again?

mandyli · Post by **mandyli** » Mon Jun 07, 2004 11:36 pm

The same topic discussed many times . if u go to director and then use "Cleanup resource " option from the Job menu.

Regds
Mandyli

Sreenivasulu · Post by **Sreenivasulu** » Tue Jun 08, 2004 12:26 am

Go to "CleanUp Resources" and try to click the "logoff" button after
selecting the appropriate job.
If this does not work then log onto the Unix box and kill the specified process

Regards

ray.wurlod · Post by **ray.wurlod** » Tue Jun 08, 2004 12:34 am

All responders (except me) have assumed what the OP meant by "locked".

Beware of assumptions. As you may already be aware, or soon enough will become aware, they are highly dangerous things in an ETL environment!

Let me also make the point that killing a process will rarely release some kinds of lock but, instead, leave the locks in a state called "held by a defunct process", which are even harder to clean up because defunct processes are not displayed in the Cleanup Resources window.

The correct mechanism for addressing the situation "job is locked" (whatever that means) is going to depend on what the OP means by "locked", which is why I asked the question and why I await the OP's response before posting again.