Deleting DBA Jobs


Just because I always forget how to do this. To delete jobs from Oracle dba_jobs use the following package

dbms_job.remove(xxx) where xxx is the job number. Don’t forget to stick execute in from of the command.


Leave a Reply

Your email address will not be published. Required fields are marked *