troubleshooting Question

rerun Oracle job and drop the Oracle job.

Avatar of marrowyung
marrowyung asked on
Oracle DatabaseSQL
35 Comments1 Solution745 ViewsLast Modified:
hi,

I used SQL developer 18.c's DBA toolbar to create the data pump job to import data and as according to the command below I want to rerun the job and/OR drop the job to recreate one,

Drop a job:

BEGIN
  DBMS_SCHEDULER.DROP_JOB ('IMPORT_CISUAT');
END;
/

error is :
Error starting at line : 49 in command -
BEGIN
  DBMS_SCHEDULER.DROP_JOB ('IMPORT_CISUAT');
END;
Error report -
ORA-27475: unknown job "SYSTEM"."IMPORT_CISUAT"
ORA-06512: at "SYS.DBMS_ISCHED", line 274
ORA-06512: at "SYS.DBMS_SCHEDULER", line 753
ORA-06512: at line 2
27475. 00000 -  "unknown %s \"%s\".\"%s\""
*Cause:    The specified object did not exist, privileges were not granted,
           or the object was of the wrong type.
*Action:   Specify an object of the correct type on which you have privileges.

to run a job I run:

/* Running Jobs */

BEGIN
   dbms_scheduler.run_job('IMPORT_CISUAT');
END;

error is:

Error starting at line : 44 in command -
BEGIN
   dbms_scheduler.run_job('IMPORT_CISUAT');
END;
Error report -
ORA-27475: unknown job "SYSTEM"."IMPORT_CISUAT"
ORA-06512: at "SYS.DBMS_ISCHED", line 238
ORA-06512: at "SYS.DBMS_SCHEDULER", line 568
ORA-06512: at line 2
27475. 00000 -  "unknown %s \"%s\".\"%s\""
*Cause:    The specified object did not exist, privileges were not granted,
           or the object was of the wrong type.
*Action:   Specify an object of the correct type on which you have privileges.

any idea on what's wrong ? I use SYSTEM account to login and run that job.

privileges  is not enough ? or can't find the object?
ASKER CERTIFIED SOLUTION
Alex [***Alex140181***]
Software Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 35 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 35 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros