Remove job from scheduler

Posted on 2007-10-15
Last Modified: 2013-12-19
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 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  /
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?
Question by:xoxomos
    LVL 18

    Expert Comment

    Enclose the JOB_NAME in double quotes ( " ) within the single quotes ( ' )


       dbms_scheduler.drop_job('"JOB WITH SPACES"');
    LVL 18

    Expert Comment

    drop the job by specifying FORCE=TRUE

    Author Comment

    SQL> begin
      2  dbms_scheduler.drop_schedule (schedule_name => "BACKUP_FISDATA.CCC.E
      3  end;
      4  /
    dbms_scheduler.drop_schedule (schedule_name => "BACKUP_FISDATA.CCC.EDU_00
    ERROR at line 2:
    ORA-06550: line 2, column 48:
    PLS-00114: identifier 'BACKUP_FISDATA.CCC.EDU_' too long
    LVL 11

    Expert Comment

    Please goto this url for answer / syntax to your problem.
    LVL 28

    Accepted Solution

    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 :

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


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    Via a live example, show how to take different types of Oracle backups using RMAN.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now