dbms_job restarts after shutdown startup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: dbms_job restarts after shutdown startup

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577

    dbms_job restarts after shutdown startup

    Hi,

    I am going crazy trying to kill a job on one of our test databases. Its taking too long and i want to kill it.

    I tried killing the session but it marks it to kill and doesnt kill the job I have even tried shutdown abort and startup but that thing keeps on starting by itself after the startup.

    I am on 10g R2 on Red Hat Linux 4.0

    Am I doing something wrong here.

    Thanks
    Ron
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    set job_queue_processes to 0 so it cant restart

    dont forget it will have to rollback anything that its done before it gets killed

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    dbms_job.remove(id);
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    dbms_job.remove just hangs as the job is still running.
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  5. #5
    Join Date
    Apr 2003
    Posts
    353
    Kill the job at database level or OS level
    then remove the job.
    You can use user_jobs_running for verifying the same.

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