cmaggiulli/kill-job.sql

Created September 4, 2019 16:37

Star (1) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/cmaggiulli/12fae0959e96ceb97592d4123f158a85.js"></script>
Save cmaggiulli/12fae0959e96ceb97592d4123f158a85 to your computer and use it in GitHub Desktop.

Download ZIP

Kills a expdp job. Need to replace C1 and OICIMPEXPUSER with the job name and job owner, respectively

Raw

kill-job.sql

	DECLARE
	h1 NUMBER;
	BEGIN
	h1:=DBMS_DATAPUMP.ATTACH('C1','OICEXPIMPUSER');
	DBMS_DATAPUMP.STOP_JOB (h1,1,0);
	END;
	/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment