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.
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.