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: firstname.lastname@example.org
Thank you in advance!