SQL & PL/SQL

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!

disable all scheduled jobs

518459Mar 24 2009 — edited Mar 24 2009

Hello,

Some time ago I tried to disable all the jobs for one user. Even though my experience with PL/SQL is minimal, I managed to do it with a very simple call of dbms_scheduler.disable.
The problem is... I can't remember anymore how I did it. Does anyone know how it is properly done?

exec sys.dbms_scheduler.disable(*) and that kind of syntax is not correct.

Thank you,
Adrian

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 21 2009

Added on Mar 24 2009

5 comments

1,197 views