asked on

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?

sventhan

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

EXAMPLE:

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

sventhan

drop the job by specifying FORCE=TRUE

xoxomos

ASKER

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

mohammadzahid

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

http://www.psoug.org/reference/dbms_scheduler.html

ASKER CERTIFIED SOLUTION

Naveen Kumar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial