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.
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
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://oracle-base.com
My blog: http://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 10 guests