Removal of a JOB without JOB number

All posts relating to Oracle database administration.

Moderator: Tim...

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,

Caesar
caesardutta
Senior Member
 
Posts: 50
Joined: Thu Jul 15, 2010 11:11 am

Re: Removal of a JOB without JOB number

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

Hi.

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?

http://www.oracle-base.com/articles/10g ... er-10g.php

Cheers

Tim...
Tim...
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: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 9 guests

cron