Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to disable other user's job using dbms_jobs Oracle 9i

Mas.dbaJun 28 2011 — edited Jun 29 2011
Hi

I have oracle 9.2.0.8 on AIX 5.3. I need to disable a dbms_stats.gather_table_stats job runing by user PERFSTAT using dbms_jobs. How can i do this ? i do not have password of PERFSTAT user.

Thanks in Advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2011
Added on Jun 28 2011
8 comments
6,476 views