Enable / Disable , Stop / Run , Drop the DBMS Scheduler jobs in Oracle
Enable a dbms scheduler job
EXECUTE DBMS_SCHEDULER.ENABLE('SCHEMANAME.JOBNAME');
Disable a DBMS Scheduler job
EXECUTE DBMS_SCHEDULER.DISABLE('SCHEMANAME.JOBNAME');
Stop a running job
EXECUTE DBMS_SCHEDULER.STOP_JOB('SCHEMANAME.JOBNAME');
Drop a running job
EXECUTE DBMS_SCHEDULER.DROP_JOB('SCHEMANAME.JOBNAME');
Run a job immediately
EXECUTE DBMS_SCHEDULER.RUN_JOB('SCHEMANAME.JOBNAME');