ORACLE-006: Remove and stop jobs, oracle006 remove jobs

ORACLE-006: Remove and stop jobs, oracle006 remove jobs

Generally, you can use SQL to delete or stop a job.

Remove JOB: remove

Stop JOB: broken

First pass

Select * from user_jobs;

Find the job id, and then call

Dbms_job.broken or

Dbms_job.remove to remove and stop. The SQL statement is as follows.

Take removing a job as an example.

1. Search for and remove a JOB based on what value of the job.

Declare job number; v_count number; begin select count (*) INTO v_count FROM user_jobs uj WHERE upper (uj. what) = UPPER ('What value during JOB creation '); if v_count> 0 then SELECT uj. job into job FROM user_jobs uj WHERE upper (uj. what) = UPPER ('What value during JOB creation '); dbms_job.remove (job); commit; end if; end;

2. If you already know the JOB id, you can directly call it.

The JOB id is the value of the JOB field of user_jobs.

Begin dbms_job.broken.remove (JOB1 ID); dbms_job.remove (JOB2 ID); end;