How to delete/remove Oracle non executing datapump jobs

 Deleting or removing Oracle non executing datapump jobs

SET lines 200

SELECT owner_name, job_name, operation, job_mode,state, attached_sessions FROM dba_datapump_jobs ORDER BY 1,2;

SELECT 'drop '||o.owner||'.'||object_name ||'OWNER.OBJECT' FROM dba_objects o, dba_datapump_jobs j WHERE o.owner=j.owner_name AND o.object_name=j.job_name AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2;