Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Droping job in all_scheduler_jobs table

Snehotosh-OracleDec 12 2008 — edited Dec 15 2008

Hi,
I am not able to drop the jobs by executing the below block in oracle 11g in windows platform:
begin
dbms_scheduler.drop_job ('IQT_1224796');
end;

Its showing the following error though the job is present.
ORA-27475:"SYS.IQT_1224796" must be a job
ORA-06512:at "SYS.DBMS_ISCHED",
ORA-06512:at "SYS.DBMS_SCHEDULER"

Plz let me know the reason.

Thanks in advance,
Snehotosh.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 12 2009

Added on Dec 12 2008

#database-key-features, #scheduler

1 comment

2,604 views