stopping jobs scheduled on the database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: stopping jobs scheduled on the database

  1. #1
    Join Date
    Dec 1999
    Posts
    217

    stopping jobs scheduled on the database

    I have a replicated environment and I need to stop the jobs from running on the target database what command would I issue.
    These jobs are owned by other users.
    Also what query would get me the job queues so that I could issue a "exec dbms_job.remove();

    Thanks in advance
    Chintz

  2. #2
    Join Date
    Dec 1999
    Posts
    217
    Thank You I figured it out. THe statementis
    exec dbms_job.remove(job_#);
    But has to be run as the job owner.

    -Chintz

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by Chintz
    Thank You I figured it out. THe statementis
    exec dbms_job.remove(job_#);
    But has to be run as the job owner.
    There is also an undocumented package SYS.DBMS_IJOB that allows you (if you are authorised to use this package) to manage jobs that are not owned by you.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Chintz
    Thank You I figured it out. THe statementis
    exec dbms_job.remove(job_#);
    But has to be run as the job owner.

    -Chintz
    How about commiting the work afterwards :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

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