 |
|
Oracle Tips by Burleson |
Chapter 2 -
Configuring Oracle Job Scheduling
Jobs
BEGIN
DBMS_SCHEDULER.copy_job (
old_job => 'test_full_job_definition',
new_job => 'new_test_full_job_definition');
END;
/
Jobs can be deleted using the drop_job
procedure listed blow.
PROCEDURE drop_job (
job_name IN VARCHAR2,
force IN BOOLEAN
DEFAULT FALSE)
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:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
