Delete job step from Oracle scheduler

!!! ATTENTION - ONLY FOR USE IN TESTING ENVIRONMENT !!!


Suppose: You killed the session of a scheduler job step, in spite of that this step and with it entire job and seemes to be keep on running (e.g. in OEM).

Solution: Find out the obj# of your job

DELETE FROM scheduler$_step_state WHERE job_oid = <your job id>;
UPDATE scheduler$_job SET job_status = job_status - bitand(job_status, 258) WHERE obj# = <your job id>;
COMMIT;