Oracle jobs to start and stop
Running a Job Manually
If you want to run a job immediately, call the dbms_scheduler.run_job procedure.
begin
dbms_scheduler.run_job (job_name => ‘oracledbwr’);
end;
/
This causes the named job to be run immediately.
Stopping Running Jobs
Running jobs can be stopped using the dbms_scheduler.stop_jobprocedure.
begin
dbms_scheduler.stop_job (job_name => ‘oracledbwr’);
end;
/
This only stops the running job and does not affect future running of this job.
Disabling and Enabling Jobs
The dbms_schedulerpackage includes the procedures disable and enable to disable and enable jobs. When a job is disabled, it will not be run.
begin
dbms_scheduler.disable (job_name => ‘oracledbwr’);
end;
/
