-
can't delete dbms_jobs
I have a dbms_job number 38. when i try to delete that using
dbms_job.remove(job => 38)
it shows as
ORA-23421: job number 38 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 529
ORA-06512: at "SYS.DBMS_JOB", line 171
ORA-06512: at line 2
but this job runs daily at 5pm.
Thanks in advance.
-
38 wont be in YOUR job list
-
So what should i do if i want delete that job which is not in job list.
-
log on as the user who owns the job
-
thanks dave.
I tried with sys user before, now it works.
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
|