How to stop a running dbms_job job
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to stop a running dbms_job job

  1. #1
    Join Date
    Jul 2000
    Location
    Koblenz, Germany
    Posts
    1

    Question

    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!

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