-
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!
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|