-
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.
-
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.
-
Are you trying to kill the job from the same schema as
the one you created it from ?
Gregg
-
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?
-
try
attempting jurij Modic(user) answer
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|