Can't manage to disable a Job.
85558Dec 16 2009 — edited Dec 16 2009I have a job that was created by a prior DBA (no longer with my company). This is the data on the job from DBA_SCHEDULER_JOB:
OWNER JOB_NAME LAST_START_DATE
------------------------------ --------------------------------------- ----------------------------------------
CDEPOT_OWNER Check File Delivery Status 16-DEC-09 10.30.00.110007 AM -05:00
REPEAT_INTERVAL ENABL
--------------------------- ---------
FREQ=MINUTELY;I TRUE
NTERVAL=30
STATE NEXT_RUN_DATE LAST_RUN_DURATION FAILURE_COUNT
----------------- ------------------------------------------------------ ------------------------------------------- ------------------------
SCHEDULED 16-DEC-09 11.00.00.000000 AM -05:00 +000000000 00:00:00.051310 15
Here's the same data (more or less) from the SYS.SCHEDULER$_JOB table:
OBJ# PROGRAM_ACTION CREATOR JOB_STATUS
------------ ------------------------------------------------------------------ ------------------------------ -------------------
121959 CDEPOT_OWNER.CHECKFILEDELIVERYSTATUS CDEPOT_OWNER 1
Okay, so I log into SQL*Plus as CDEPOT_OWNER and try to disable the job:
begin
dbms_scheduler.disable('Check File Delivery Status');
end;
/
begin
*
ERROR at line 1:
ORA-00931: missing identifier
ORA-06512: at "SYS.DBMS_UTILITY", line 132
ORA-06512: at "SYS.DBMS_UTILITY", line 164
ORA-06512: at "SYS.DBMS_UTILITY", line 218
ORA-06512: at "SYS.DBMS_SCHEDULER", line 540
ORA-06512: at line 2
This is the SAME command that I've used to disable other jobs I've created (also as CDEPOT_OWNER). I'm stumped as to why it won't let me disable this job and I really NEED to disable this job ASAP 'cause it's causing problems for other processes. Any and all assistance gratefully accepted.
Leigh Smith