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
roblvl
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
G.Mohan


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: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBA_JOBS
DBA_JOBS_RUNNING

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

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


Current Time: Mon Dec 05 20:56:47 CST 2016

Total time taken to generate the page: 0.10897 seconds