How to get rid of jobs / dbms_job (old style) that you don't own
Do you have some legacy DBMS_JOBS hanging out there running – that somebody left – and abandoned to “rust”. Need to get rid of them even though you don’t own them? Try this as long as you can connect as sysdba: –select * from dba_jobs; set heading off set feedback off select ‘execute sys.dbms_ijob.remove(‘||trim(to_char(job))||’);’ from …
How to get rid of jobs / dbms_job (old style) that you don't own Read More »