Writing Custom Scripts to Execute Batch Jobs

Back Next

CMXBG.RESET_BATCHGROUP

Reset Batch Group Status jobs resets a batch group.

In addition to this stored procedure, there are Java API requests and the SOAP and HTTP XML protocols available using Services Integration Framework (SIF). The Reset Batch Group Status job has the following SIF API requests available: ResetBatchGroup.

Signature

FUNCTION CMXBG.RESET_BATCHGROUP(
  IN_MRM_SERVER_URL         IN VARCHAR2(500)
, IN_USERNAME               IN VARCHAR2(500)
, IN_PASSWORD               IN VARCHAR2(500)
, IN_ORSID                  IN VARCHAR2(500)
, IN_BATCHGROUP_UID         IN VARCHAR2(500)
, OUT_ROWID_BATCHGROUP_LOG  OUT VARCHAR2(500)
, OUT_ERROR_MSG             OUT VARCHAR2(500)
) RETURN NUMBER --Return the error code

Parameters

Name	Description
IN_MRM_SERVER_URL	Hub Server SIF URL.
IN_USERNAME	User account with role-based permissions to execute batch groups.
IN_PASSWORD	Password for the user account with role-based permissions to execute batch groups.
IN_ORSID	ORS ID as specified in the Database tool in the Hub Console.
IN_BATCHGROUP_UID	Informatica MDM Hub Object UID of batch group to [execute, reset, get status of, and so on].

Returns

Parameter	Description
OUT_ROWID_BATCHGROUP_LOG	c_repos_job_group_control.rowid_job_group_control
OUT_ERROR_MSG	Error message text.
NUMBER	Error code. If zero (0), then the stored procedure completed successfully. If one (1), then the stored procedure returns an explanation in out_error_msg.

Sample Job Execution Script for Reset Batch Group Jobs

DECLARE
   OUT_ROWID_BATCHGROUP_LOG      CMXLB.CMX_SMALL_STR;
   OUT_ERROR_MSG                 CMXLB.CMX_SMALL_STR;
   RET_VAL                       INT;
BEGIN
   RET_VAL := CMXBG.RESET_BATCHGROUP(
      'HTTP://LOCALHOST:7001/CMX/REQUEST/PROCESS/'
      , 'ADMIN'
      , 'ADMIN'
      ,'LOCALHOST-MRM-XU_3009'
      , 'BATCH_GROUP.MYBATCHGROUP'
      , OUT_ROWID_BATCHGROUP_LOG
      , OUT_ERROR_MSG
   );
   CMXLB.DEBUG_PRINT('RESET_BATCHGROUP: CODE=' || RET_VAL || ' MESSAGE=' || OUT_ERROR_MSG || ' OUT_ROWID_BATCHGROUP_LOG=' || OUT_ROWID_BATCHGROUP_LOG);
/

Rename Saved Search

Table of Contents

Writing Custom Scripts to Execute Batch Jobs

Writing Custom Scripts to Execute Batch Jobs

CMXBG.RESET_BATCHGROUP

CMXBG.RESET_BATCHGROUP

Signature

Parameters

Returns

Sample Job Execution Script for Reset Batch Group Jobs