Hi all,
I have been developing a procedure and a related DBMS_SCHEDULER job in my personal schema ("B3FOREMAN"). Now I want to deploy both the procedure and the job to the production schema ("DBAETL").
So I logged in as "DBAETL" and created the procedure, then tried to create the DBMS_SCHEDULER job but found that DBAETL didn't have privileges to create a job. Rather than working through the permissions, I just connected to my DBA account ("B3FOREMAN") again and created it from there, prefixing the job name with the schema "DBAETL", so that that schema would own it.
Now somehow I have ended up in a situation where the job is not listed in DBA_SCHEDULER_JOBS, nor is it in DBA_SCHEDULER_RUNNING_JOBS, but if I try to create it I get ORA-27477 "already exists". If I try to drop it I get ORA-27475 "must be a job". It's as if it's both there and not there---but according to DBA_SCHEDULER_JOBS, it's NOT there.
I'm on Oracle 11.2.0.3; if anyone has seen this before and knows the trick that would be great. Thanks!
Brian