Database Administration (MOSC)

MOSC Banner

DBMS_Scheduler job removal

edited Feb 14, 2011 8:01AM in Database Administration (MOSC) 8 commentsAnswered
 Hi ,

I am trying to remove the job from RAC database 10.2.0.4 but getting below error:

It is not in sys user but under an application user.

SQL> BEGIN

DBMS_SCHEDULER.DROP_JOB (
job_name => 'RUN_HDER');
END;
/  2    3    4    5
BEGIN
*
ERROR at line 1:
ORA-27475: "SYS.RUN_HDER" 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

Regards

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center