Skip to Main Content

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!

dbms_job.remove

743517Jul 28 2011 — edited Jul 28 2011
I have some jobs scheduled.I am querying the table user_jobs there i am getting 50 rows.I want to remove the job.

i am executing the statement below through a sql statement:

exec dbms_job.remove(110) ;
exec dbms_job.remove(200);
.................
.................
..................
where 110,200 is the job[obtained from user_jobs].

The execution is taking long time. Does anybody has knowlegde how to remove oracle scheduled job?

Thanks in advance...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2011
Added on Jul 28 2011
2 comments
3,778 views