Manually Dropping a Scheduled Job 301
Manually Dropping
a Scheduled Job
To kill or drop a job, acquire the job number and then drop the job from
using the SQL Plus command line.
Manually Acquiring
a Job Number
To acquire a submitted job number:
1 From a SQL Plus command line, login as the cwbss user.
2 Enter one of the following scripts:
■ SELECT JOB FROM USER_JOBS;
■ SELECT JOB_NUMBER, JOB_TO_SUBMIT FROM JOB_DELETE_CDRS;
The script returns the job number.
Manually Dropping a
Job
To drop a job:
1 From a SQL Plus command line, login as the cwbss user.
2 Enter the following script:
set serveroutput on
begin
DBMS_JOB.REMOVE(job_number);
end;
Manually Resuming
a Broken Job
To resume a broken job, acquire the broken job number, fix the problem,
and then resume the job using a SQL Plus command line.
Manually Acquiring
a Broken Job Number
To acquire a broken job number:
3 From a SQL Plus command line, login as the cwbss user.
4 Execute the SQL script:
SELECT JOB, BROKEN FROM USER_JOBS;
The job number can be identified by viewing the JOB number where the
BROKEN status is Y.
