Removal of a JOB without JOB number

All posts relating to Oracle database administration.

Moderator: Tim...

Senior Member
Posts: 58
Joined: Thu Jul 15, 2010 11:11 am

Removal of a JOB without JOB number

Postby caesardutta » Thu Jan 17, 2013 5:48 am

Dear Sirs and Tim:

A belated Happy and Prosperous 2013 to all.

Recently I received a request from application team that a certain DBMS job having name ROLLBACK_CREDITS needs to be removed from the system.

I know that DBMS_JOB.REMOVE procedure accepts JOB number as the parameter.

Now going through DBA_JOBS and other SCheduler views I am not able to get JOB number against a JOB name.

I need your help on this.

Platform is Oracle 10G R2 running on RHEL Enterprise for Itanium.

Warm regards,


Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Removal of a JOB without JOB number

Postby Tim... » Thu Jan 17, 2013 9:51 am


In 10g there are two scheulers. The one you access with DBA_JOBS and DBMS_JOB and the one you access with DBA_SHEDULER_JOBS and DBA_SCHEDULER. It sounds to me like you are only considering the old scheduler. Has the job been scheduled using the new scheduler? ... er-10g.php


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests