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!
In DBMS_JOBS_RUNNING you can find the sid of the session.
Use this sid to identify the session in v$session and kill the session with:
'alter system kill session 'sid,serial#';'
Don't forget to mark the job as broken or remove it from the job queue.