job is locked while creating the copy

[Prashantoncyber]

Hi All

I can open the job sccessfully.

But When i am trying to create the copy of job its telling

that job is locked. I wondering about this scenario.

thanks

Prashant

[hexa]

Try this command from Administrator

UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' WHERE NAME = '<Job Name>';

Regards
Hexa

[Prashantoncyber]

Try this command from Administrator

UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' WHERE NAME = '<Job Name>';

Regards
Hexa


Hi Hexa,

when i executed this command from Administrator,

It says that 1 reacord is updated.

Subsequently , my problem is resolved.

Can you give some insight how what this command does?

and where to refer & how to learn more about this type commands to

resolve our problems in future.

Many thanks

Prashant

[ray.wurlod]

It does something completely unnecessary to recover from a locked job; it sets a "read only" flag to 'NRO' when it was already 'NRO'!

The long and short of your original problem is that you tried to take a copy of a job that was already open - whether in Designer, Manager or Director (Monitor) - or currently running. The DataStage Repository is a database; it uses row level locking to protect objects from inadvertent updates. This is what you encountered.

Chances are that you closed the open connection when you opened the Administrator client, which is why you believe that the update command solved your problem.