Remove job from scheduler
Posted on 2007-10-15
Oracle 10g R2 running under Windows
I accidently scheduled a job through OEM. I've tried to delete but but it keeps recurring even though i said for it to delete all occurances.
Select Name Status (Executions) Scheduled Targets Target Type Owner Job Type
BACKUP_FISDATA.CCC.EDU_000204 1 Scheduled Oct 16, 2007 9:10:00 AM GMT-07:00 fisdata.ccc.edu Database Instance SYS Database Backup
I then tried to go into sqlplus to delete:
2 dbms_scheduler.drop_job (
3 job_name => 'BACKUP_FISDATA.CSUEASTBAY.EDU_0002004');
ERROR at line 1:
ORA-27475: "BACKUP_FISDATA.CCC..EDU_0002004" must be a job
ORA-06512: at "SYS.DBMS_ISCHED", line 178
ORA-06512: at "SYS.DBMS_SCHEDULER", line 544
ORA-06512: at line 2
What do i need to do to get it off the scheduler?