-
SQL> select * from dba_jobs;
JOB LOG_USER PRIV_USER
--------- ------------------------------ -----------
10 DEMO_320 DEMO_320
INSTANCE
--------
0
How can i remove this, if i try the following:
SQL> execute dbms_job.remove(10);
BEGIN dbms_job.remove(10); END;
*
ERROR at line 1:
ORA-23421: job number 10 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 525
ORA-06512: at "SYS.DBMS_JOB", line 166
ORA-06512: at line 1
please help
-
do you try to remove this job while being connected as the owner of it ??? if not this is a normal behaviour ...
-
thanks, i thought i had tried to remove with owner, but it seems i didnt.
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
|