DSXchange

What needs to be done if a job gets locked ?

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

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?

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

Regds
Mandyli

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

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.