Oracle: Stop a datapump job run via crontab

Show datapump jobs

1	select * from dba_datapump_jobs;

Stop a datapump job

1 2 3 4 5 6 7

DECLARE    handle NUMBER; BEGIN     -- Format: DBMS_DATAPUMP.attach('[job_name]','[owner_name]');     handle := DBMS_DATAPUMP.attach('SYS_EXPORT_FULL_02','SYSTEM');     DBMS_DATAPUMP.STOP_JOB(handle, 1, 0); END;