rem
rem This script can be used to abort a deployment job at the Unit level.
rem
rem A Deployment Unit is a collection of objects that are being deployed
rem to the same location with the same Deployment Action.
rem
rem USAGE
rem Logon as WorkspaceOwner or WorkspaceUser with Admin privilege
rem    
rem    @<OWB-HOME>/owb/rtp/sql/abort_unit_request.sql <auditid> <workspace>
rem
rem For a given audit-id which represents a deployment unit job, this script will
rem abort it so that the job is terminated in a managed way. The audit-id
rem may have been obtained by using the list_requests.sql script
rem
rem The given workspace is the one in which the job is running
rem <workspace> should be declared as workspaceOwner.workspaceName
rem if only workspaceName is given, workspaceOwner will be defaulted to user
rem

set verify off;

set role OWB_USER;
call owbsys.wb_rt_script_util.set_workspace('&2.');

declare
  l_audit_id number;
  
begin
  l_audit_id := &1.;
  owbsys.wb_rt_script_util.abort_unit_request(l_audit_id);
  
end;
/