How do I kill a non-running impdp job?
You can drop export/import job using the following command
First of all find the name of the job table under 'DataPump>Import Jobs or Export Jobs'.



Use the drop command to drop that table by the user who has created that import/export job. In my case it was created by SYSTEM user.


SQL>conn system/password
SQL>DROP TABLE EXPORT_JOB_SQLDEV_41;
Table dropped.