I have a quick question.
How can I delete a job and it's in dba_jobs????
right now I have three jobs in dba_jobs but I want to delete two of them out.
Please advise
Printable View
I have a quick question.
How can I delete a job and it's in dba_jobs????
right now I have three jobs in dba_jobs but I want to delete two of them out.
Please advise
To delete the JOB, you should be the owner . That means you have to login as the schema owner and give a try
please post the command of how to delete the jobs ???
Thanks
exec dbms_job.remove(job#);
Ah, not exactly true mrvajrala, one does not have to be the owner, see
http://www.dbasupport.com/forums/showthread.php?t=8288
If you are able to connect as SYS you can use SYS.dbms_ijob.remove(); followed by a commit.