rem
rem This script can be used to deactivate a deployment job.
rem
rem USAGE
rem Logon as WorkspaceOwner or WorkspaceUser with Admin privilege
rem    
rem    @<OWB-HOME>/owb/rtp/sql/deactivate_deployment.sql <auditid> <workspace>
rem
rem For a given audit-id which represents a deployment job, this script will
rem deactivate it so that the job and all of its unit-jobs are terminated in a
rem managed way. The audit-id may have been obtained by using the
rem 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
begin
  owbsys.wb_rt_script_util.deactivate_deployment(&1.);
  
end;
/