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.
Printable View
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
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.Quote:
Originally posted by bk_raavi
declare
Begin
dba_jobs.Remove(125);
End;
/
But it is giving 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;
try
attempting jurij Modic(user) answer
Quote:
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.
Not a problem.Code:SQL> declare
2 begin
3 null;
4 end;
5 /
PL/SQL procedure successfully completed.
SQL>