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

Thread: Killing Of Jobs

  1. #1
    Join Date
    Apr 2003
    Location
    Hyderabad
    Posts
    40

    Killing Of Jobs

    How to kill Job;
    I creted a Job with Id 125;
    how kill that Job;
    I write
    declare
    Begin
    dba_jobs.Remove(125);
    End;
    /

    But it is giving error


    Any body Please give the Solution.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    IT would be helpful if you posted the error message. You should post the code that you ran and all of the messages you recieved from Oracle if you want help. Also take a look at the Alert.log.

  3. #3
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    Are you trying to kill the job from the same schema as
    the one you created it from ?

    Gregg

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: Killing Of Jobs

    Originally posted by bk_raavi
    declare
    Begin
    dba_jobs.Remove(125);
    End;
    /

    But it is giving error
    So what do you need your DECLARE section for? You have nothing in it, not a single declaration, so I'm not surprised you are getting an error.

    Besides, there is no such package as DBA_JOBS, from which you are calling procedure REMOVE. You need to use package DBMS_JOB, like:

    Code:
    begin
      dbms_job.remove(125);
      commit;
    end;
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Apr 2003
    Location
    Vijayawada-INDIA
    Posts
    14
    try
    attempting jurij Modic(user) answer

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253

    Re: Re: Killing Of Jobs

    Originally posted by jmodic
    So what do you need your DECLARE section for? You have nothing in it, not a single declaration, so I'm not surprised you are getting an error.
    Code:
    SQL> declare
      2  begin
      3  null;
      4  end;
      5  /
    
    PL/SQL procedure successfully completed.
    
    SQL>
    Not a problem.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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