• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 13917
  • Last Modified:

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?
0
xoxomos
Asked:
xoxomos
1 Solution
 
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
 
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

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now