how to delete jobs in dba_jobs.

[ashley75]

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

[mrvajrala]

To delete the JOB, you should be the owner . That means you have to login as the schema owner and give a try

[ashley75]

please post the command of how to delete the jobs ???

Thanks

[stecal]

exec dbms_job.remove(job#);

[pobby69]

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.