-
a user have a job, this user was deleted, and the job stay in the database, when this job try to run a process into a database, it generate a error, it don't find the process in the user tha was deleted,
how can i delete a job with system from another user?
i try with
execute dbms_job.remove(job)
but ORA-23421: job number 1 is not a job in the job queue
SQL> EXECUTE DBMS_JOB.REMOVE (1);
BEGIN DBMS_JOB.REMOVE (1); END;
*
ERROR at line 1:
ORA-23421: job number 1 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 83
ORA-06512: at "SYS.DBMS_JOB", line 91
ORA-06512: at "SYS.DBMS_JOB", line 152
ORA-06512: at line 1
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|