drop job

We create jobs and can schedule it by using DBMS_SCHEDULER package. We can also use this package for to stop or drop the job. There are two separate procedure(stop_job and drop_job) exists in the package. In some cases you will have to use the force option to stop the job. Let start to example SQL> Continue reading