Hi!

when I start a job using dbms_job.submit and the job runs in a loop (e.g. waits for a event from advance queuing) - how do I stop this job?

There is no "dbms_job.stop" or something else. OK, I can kill the correspondending SNP process on my server, but I want to do it with Oracle only.

Please reply also to my emai address: boris.klug@ibs-ag.de

Thank you in advance!