The Oracle (tm) Users' Co-Operative FAQ

How do I identify and remove a job from the job queue.


Author's name: Dan Harvey

Author's Email:

Date written: 5th March 2003

Oracle version(s): 7.3.4

How do I identify and remove a job from the job queue.

Back to index of questions


From SQL+, execute the following statement to identify all jobs and what they do in your DMBS_JOBS job queue:

	SELECT
		job,
		what,
		last_date,
		last_sec,
		next_date,
		next_sec
	FROM 
		ALL_JOBS;

Then select the one(s) you wish to remove (permanently) and execute the following anonymous block (substituting the job number for job):

	begin
		dbms_job.remove(job);
	end;

Note that any currently running jobs (check date/times returned from your select) will not be removed until it finishes.


Further reading: N/A


Back to top

Back to index of questions