Useful shortcuts for vi editor

Tuesday 7 October 2014

How to remove a job in Oracle?

Please run that SQL lines in your editor's command window.

begin

 sys.dbms_job.remove(100);
commit;
end;

100; job id

If you do not know desired job id, you can follow this link to learn.

Note: You have to login to database as SYS user for run SQL.