QPR Knowledge Base 2019.1

Revision history:

Introduced in QPR 7.5.1

Last changed in QPR 2012

 

Runs an integration task identified either by task ID, task name, or by a series reference.

 

Synopsis:

 

SCModel.ExecuteIntegrationTask(TaskId | TaskName | SeriesReference)

 

Parameters:

 

TaskId: Integer. ID of an integration task to be run.

TaskName: String. Name of an integration task to be run.

SeriesReference: String. Reference to a series which has SQL import task defined. Syntax for this parameter is SCSYMBOL.MEASYMBOL.SERSYMBOL, in which SCSYMBOL = scorecard identifier, MEASYMBOL = measure identifier, and SERSYMBOL = series identifier.

 

Required Rights:

 

Administrator or Model Administrator rights to the SCModel.

 

Return Values:

Below are listed the return values that this function can return:

 

RV_APPLICATION_QUIT_CALLED

RV_NOT_CONNECTED_TO_SERVER

RV_NOT_AUTHENTICATED

RV_SUCCESS

RV_MODEL_NOT_OPEN

RV_NO_RIGHTS

RV_INVALID_PARAMETER

RV_OBJECT_NOT_FOUND

RV_TASK_FAILED

 

Example Procedure:

 

iRet = SCModel.ExecuteIntegrationTask('SC1.MEA1.ACT')