DBMS Job

[richardson]

How to create a job.how could it be efficiently managed without any locks occuring while a job runs.The scope and how to construct an effecient job.

[Dave44]

How to create a job.how could it be efficiently managed without any locks occuring while a job runs.The scope and how to construct an effecient job.

creating a job is easy, just look at the api for dbms_job. Locks have nothing to do with creating a job. locks are created and released by the code that the job would run.
Remember a lock is not necessarily a bad thing, and a database would be useless without them. So it all comes down to the code that your job runs.. which you have provided no information for so i cant say anything about it.

[amitpatel66]

How to create a job.how could it be efficiently managed without any locks occuring while a job runs.The scope and how to construct an effecient job.

Well locking of tables/rows in a table depends upon what your JOB is actually doing?
And you need to handle the JOB executions in proper way avoiding a deadlock by scheduling them properly.

[debasisdas]

try the sample code in the attached file.