How to control data pump job.

This steps help you to control/stop/resume/kill data pump job. For control data pump job at first you have to identify the job name from DBA_DATAPUMP_JOBS View and then you can control the job using expdp/impdp by providing the value (JOB_NAME) of attach parameter.

1. Identify the jobs which you want to control.

SQL> SELECT JOB_NAME

FROM DBA_DATAPUMP_JOBS

WHERE STATE<>'NOT RUNNING';  2    3

JOB_NAME

------------------------------

SYS_IMPORT_SCHEMA_06

SYS_IMPORT_SCHEMA_07

2. Control the job using expdp/impdp

bash-4.2$ impdp system/password attach=SYS_IMPORT_SCHEMA_07

3. Kill the job

Import>

Import> kill_job

Are you sure you wish to stop this job ([yes]/no): yes

bash-4.2$