DBMS_JOB syntax query - how to delete/disable job
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: DBMS_JOB syntax query - how to delete/disable job

Hybrid View

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    DBMS_JOB syntax query - how to delete/disable job

    How do you disable or delete a scheduled job? (In 8.1.5.0)

    I'm RTFM but can't seem to find what I want.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    I doubt you RTFM, go read supplied pl/sql reference guide

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: DBMS_JOB syntax query - how to delete/disable job

    Originally posted by JMac
    How do you disable or delete a scheduled job? (In 8.1.5.0)

    I'm RTFM but can't seem to find what I want.
    You should have STFW

    http://download-east.oracle.com/docs.../jobq.htm#1057
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Thanks chaps, you are so understanding and supportive.


  5. #5
    Join Date
    Mar 2003
    Location
    Dallas, TX
    Posts
    12
    BEGIN dbms_job.broken(3,TRUE,'');END;
    commit;

    where 3 is the jobno.

    I just posted an integrated set of GUI tools to administer and tune the Oracle database. One of the many functions is a GUI interface to manage the Oracle Jobs.
    Feel free to contact me, if you need help (michelbartov@yahoo.com). The link is http://www.barsoft.net/
    Last edited by mbartov; 04-25-2003 at 11:24 AM.

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by mbartov
    BEGIN dbms_job.broken(3,FALSE,'');END;
    commit;
    Err, the second parameter in the above call to BROKEN procedure should have been TRUE, not FALSE. Yes, I know, a typo...
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  7. #7
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405

    Re: DBMS_JOB syntax query - how to delete/disable job

    Originally posted by JMac
    How do you disable or delete a scheduled job? (In 8.1.5.0)

    I'm RTFM but can't seem to find what I want.
    Disable => dbms_job.broken
    Delete => dbms_job.remove

    Just try desc "dbms_job"
    -nagarjuna

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