Remove job from scheduler

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:



SQL> begin
  2  dbms_scheduler.drop_job (
  3  job_name => 'BACKUP_FISDATA.CSUEASTBAY.EDU_0002004');
  4  end;
  5  /
begin
*
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?
xoxomosAsked:
Who is Participating?
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
run the below query and find the job which you wanted to drop.

SELECT *
FROM dba_scheduler_jobs;

pick the job_name column from the above output and then run the below :

begin
 dbms_scheduler.drop_job (
 job_name => 'MY_TESTJOB', force=>true);
 end;
/

Thanks
0
 
sventhanCommented:
Enclose the JOB_NAME in double quotes ( " ) within the single quotes ( ' )

EXAMPLE:

   dbms_scheduler.drop_job('"JOB WITH SPACES"');
0
 
sventhanCommented:
drop the job by specifying FORCE=TRUE
0
 
xoxomosAuthor Commented:
SQL> begin
  2  dbms_scheduler.drop_schedule (schedule_name => "BACKUP_FISDATA.CCC.E
DU_000204");
  3  end;
  4  /
dbms_scheduler.drop_schedule (schedule_name => "BACKUP_FISDATA.CCC.EDU_00
0204");
                                               *
ERROR at line 2:
ORA-06550: line 2, column 48:
PLS-00114: identifier 'BACKUP_FISDATA.CCC.EDU_' too long
0
 
mohammadzahidCommented:
Please goto this url for answer / syntax to your problem.

http://www.psoug.org/reference/dbms_scheduler.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.