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
I tried with sys user before, now it works.
Click Here to Expand Forum to Full Width