Chapter 2 -
Configuring Oracle Job Scheduling
||Oracle Tips by Burleson
old_job => 'test_full_job_definition',
new_job => 'new_test_full_job_definition');
Jobs can be deleted using the drop_job
procedure listed blow.
PROCEDURE drop_job (
job_name IN VARCHAR2,
force IN BOOLEAN
The parameters associated with this procedure
and their usage are as follows:
job_name - A name that
identifies a single job, a job class name or a comma separated list.
force - TRUE running jobs are
stopped before the job is dropped. When FALSE, dropping a job that
is running will fail.
The following code shows how the drop_job
procedure can be used:
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA