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!

best way to stop / cancel / kill a job? DBMS_JOB.SUBMIT? all_jobs?

444284May 22 2007 — edited May 23 2007
I have function that uses DBMS_JOB.SUBMIT to launch an oracle job in 9i. I call that function from asp.net web page.

I need a function that stop the job. What PL-SQL safely kills an oracle job?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 20 2007
Added on May 22 2007
6 comments
5,066 views