Home » SQL & PL/SQL » SQL & PL/SQL » Regarding oracle jobs (Oracle 9i )
Regarding oracle jobs [message #412846] Mon, 13 July 2009 01:26 Go to next message
Messages: 27
Registered: June 2003
Junior Member
Hi all

I have a package in an user A,in which i have some procedures ,
which selects the data from a particular table and creates an
record in naother table . the calling of the procedures is achieved through oracle jobs .

there are also other users in the same database ,with dba rights , who has access to the tables of user A .

Off late ,there has been some duplicates created by the procedures.

I feel that the job for calling the creation procedure ,is setup in 2 users ,and they are calling the job at the same time
and the procedure is getting executed twice ,and because of this there are some duplicates

Is there anyway to find out if there are 2 jobs on 2 differnt users on the same database calling the same proc.

Thanks in advance

Re: Regarding oracle jobs [message #412849 is a reply to message #412846] Mon, 13 July 2009 01:37 Go to previous message
Michel Cadot
Messages: 65134
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

select * from dict
where table_name like '%JOB%' or upper(comment) like '%JOB%';

Previous Topic: check string for numbers and special characters
Next Topic: ORA-6513
Goto Forum:

Current Time: Wed Aug 16 14:27:49 CDT 2017

Total time taken to generate the page: 0.10474 seconds