DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: how to delete jobs in dba_jobs.

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    I have a quick question.

    How can I delete a job and it's in dba_jobs????

    right now I have three jobs in dba_jobs but I want to delete two of them out.

    Please advise


  2. #2
    Join Date
    Feb 2001
    Posts
    290
    To delete the JOB, you should be the owner . That means you have to login as the schema owner and give a try
    Madhu Reddy
    xdollor@yahoo.com

  3. #3
    Join Date
    Jan 2002
    Posts
    474
    please post the command of how to delete the jobs ???

    Thanks

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    exec dbms_job.remove(job#);

  5. #5
    Join Date
    Feb 2011
    Location
    Norwich, UK
    Posts
    5
    Ah, not exactly true mrvajrala, one does not have to be the owner, see
    http://www.dbasupport.com/forums/showthread.php?t=8288

    If you are able to connect as SYS you can use SYS.dbms_ijob.remove(); followed by a commit.

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