Cleanup orphaned datapump jobs

Assume you have some old datapump job, not running for ages:

SQL> select owner_name, job_name,state from dba_datapump_jobs;

OWNER_NAME JOB_NAME STATE
--------------------------------------------------------------------------
SYSTEM TAB_TOREDDTA EXECUTING
DATAPUMP SYS_EXPORT_TABLE_01 NOT RUNNING


You can try attach to this job to use kill_job like this:

expdp datapump/pass@schema attach=SYS_EXPORT_TABLE_01

But in this step you may have a lot of different errors that caused you are not able to attach. How to get rid of this job?
You need to delete master table/ First find it:

SQL> select owner,object_name,status,object_id from dba_objects where object_name = 'SYS_EXPORT_TABLE_01'

OWNER OBJECT_NAME STATUS OBJECT_ID
-------------------- ------------------------------ ------- ----------
DATAPUMP SYS_EXPORT_TABLE_01 VALID 88842

Then drop it:

drop table datapump.SYS_EXPORT_TABLE_01;

And check whether it helps:

SQL> select owner_name, job_name,state from dba_datapump_jobs;

OWNER_NAME JOB_NAME STATE
------------------------------ -----------------------------------------
SYSTEM TAB_TOREDDTA EXECUTING