Menu
I created a job named ENTRY_TIME
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'ENTRY_TIME',
job_type => 'STORED_PROCEDURE',
job_action => 'PK_ENTRY_TIME.PROC_ENTRY_TIME',
start_date => '24-MAY-16 07.00.00 AM America/Chicago',
repeat_interval => 'FREQ=DAILY',
end_date => '20-NOV-99 07.00.00 AM America/Chicago',
auto_drop => FALSE,
comments => 'My new job');
END;
/
Now I want to drop this job.What query should be used to drop this job Entry_time permanently?
309
In Oracle, you can remove a job from the job queue using the Oracle DBMS_JOB. REMOVE statement.
Use the DROP TYPE statement to drop the specification and body of an object type, a varray, or a nested table type. See Also: DROP TYPE BODY for information on dropping just the body of an object type. CREATE TYPE and ALTER TYPE for information on creating and modifying types.
For auto drop,This flag if TRUE, causes a job to be automatically dropped after it has completed or has been automatically disabled. A job is considered completed if: 1. Its end date (or the end date of the job schedule) has passed. 2.It has run max_runs number of times. max_runs must be set with SET_ATTRIBUTE.
The DBMS_SCHEDULER package provides a collection of scheduling functions and procedures that are callable from any PL/SQL program.
BEGIN
dbms_scheduler.drop_job(job_name => 'ENTRY_TIME');
END;
/
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With