Writing Custom Scripts to Execute Batch Jobs

Back Next

CMXBG.EXECUTE_BATCHGROUP

Execute Batch Group jobs execute a batch group. Execute Batch Groups jobs have an option to execute asynchronously, but not to receive a JMS response for asynchronous execution. If you need to use asynchronous execution and need to know when execution is finished, then poll with the cmxbg.get_batchgroup_status stored procedure. Alternatively, if you need to receive a JMS response for asynchronous execution, then execute the batch group directly in an external application (instead of a job execution script) by invoking the SIF ExecuteBatchGroup request.

Signature

FUNCTION CMXBG.EXECUTE_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)
, IN_RESUME                 IN VARCHAR2(500)
, IN_ASYNCRONOUS            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 shown in Console > Configuration > Databases .
IN_BATCHGROUP_UID	Informatica MDM Hub Object UID of batch group to [execute, reset, get status, etc.].
IN_RESUME	One of the following values: true: if previous execution failed, resume at that point false: regardless of previous execution, start from the beginning
IN_ASYNCRONOUS	Specifies whether to execute asynchronously or synchronously. One of the following values: true: start execution and return immediately (asynchronous execution). false: return when group execution is complete (synchronous execution).

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 Execute 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.EXECUTE_BATCHGROUP(
            'HTTP://LOCALHOST:7001/CMX/REQUEST/PROCESS/'
            , 'ADMIN'
            , 'ADMIN'
            , 'LOCALHOST-MRM-XU_3009'
            , 'BATCH_GROUP.MYBATCHGROUP'
            , 'true' -- OR 'false'
            , 'true' -- OR 'false'
            , OUT_ROWID_BATCHGROUP_LOG
            , OUT_ERROR_MSG
      );
   CMXLB.DEBUG_PRINT('EXECUTE_BATCHGROUP:    ' || ' CODE='|| RET_VAL || ' MESSAGE='|| OUT_ERROR_MSG ||    ' | OUT_ROWID_BATCHGROUP_LOG='|| OUT_ROWID_BATCHGROUP_LOG);
   );
   COMMIT;
END;

Rename Saved Search

Table of Contents

Writing Custom Scripts to Execute Batch Jobs

Writing Custom Scripts to Execute Batch Jobs

CMXBG.EXECUTE_BATCHGROUP

CMXBG.EXECUTE_BATCHGROUP

Signature

Parameters

Returns

Sample Job Execution Script for Execute Batch Group Jobs