DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2000
    Koblenz, Germany



    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!

  2. #2
    Join Date
    Jul 2000
    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.