Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtp\sql\expedite_exec_request.sql
rem rem This script can be used to expedite an execution job. rem rem USAGE rem Logon as WorkspaceOwner or WorkspaceUser with Execute/Deploy/Admin privilege rem rem @<OWB-HOME>/owb/rtp/sql/expedite_exec_request.sql <auditid> <return-number> <return-code> <workspace> rem rem For a given audit-id which represents a execution job, this script will rem expedite the job in a managed way. The audit-id may have been obtained by rem using the list_requests.sql script rem rem The return-number and return-code are the result values assigned to the job rem rem return_number should have values:- rem 1 meaning OK rem 2 meaning OK_WITH_WARNINGS rem 3 meaning FAILURE rem rem return_code is what the Operating System return code might be rem e.g >0 normally means Failure rem =0 normally means Success 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('&4.'); declare l_audit_id number; l_return_number number; l_return_code number; begin l_audit_id := &1.; l_return_number := &2.; l_return_code := &3.; owbsys.wb_rt_script_util.expedite_exec_request(l_audit_id, l_return_number, l_return_code); end; /
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de