|
TEST_CONFIGURATION1.CREATE_CONFIGURATION(
|
| ETL_TOOL:SSIS,
|
| ETL_TOOL_V:"12.0",
|
| ETL_SERVER_ADDRESS: "localhost",
|
| ETL_SERVER_OS: WINDOWS,
|
| DWH_DB: MSSQL,
|
| DWH_DB_V: "12.0",
|
| DWH_DB_ADDRESS: "localhost",
|
| DWH_DB_OS: WINDOWS,
|
| DWH_DB_AUTH: "Windows",
|
| ENVIRONMENT: "TEST Architecture",
|
| ENVIRONMENT_DESC: "Test architecture for ETLCL language"
|
|
);
|
|
MSSQL_job.CREATE_SCHEDULER_TYPE(
|
| REFRESH_TIME_IN_SEC:10,
|
| LOG_DETAIL_F: 1
|
|
);
|
|
TestEnv.CREATE_ENVIRONMENT(
|
| ENVIRONMENT_DESCRIPTION:"Test"
|
|
);
|
|
Test_context.CREATE_CONTEXT(
|
| DESCRIPTION:'Test context,
|
| ENVIRONMENT_NAME: TestEnv
|
|
);
|
|
TestLoad
.CREATE_LOAD(
|
|
LOAD_NAME: Test_load
|
|
);
|
|
MSSQL_PROCEDURE.CREATE_AGENT_TYPE(
|
| DESCRIPTION:"MSSQL PROCEDURE agent type"
|
|
);
|
|
SQL_PROCEDURE.CREATE_AGENT(
|
| AGENT_TYPE_NAME: MSSQL_PROCEDURE,
|
| ENVIRONMENT_NAME: TestEnv
|
|
);
|
|
Test
_load.CREATE_GROUP(
|
| GROUP_NAME: Group1
|
|
);
|
|
Gr
oup
1.CREATE_TASK(
|
| TASK_UNIQUE_ID: T1,
|
| TASK_NAME: "Package1.dtsx",
|
| AGENT_NAME: SQL_PROCEDURE
|
|
);
|
|
Gr
oup
1.CREATE_TASK(
|
| TASK_UNIQUE_ID: T2,
|
| TASK_NAME: "Package2.dtsx",
|
| AGENT_NAME: SQL_PROCEDURE
|
|
);
|
|
Gr
oup
1.CREATE_TASK(
|
| TASK_UNIQUE_ID: T3,
|
| TASK_NAME: "Package3.dtsx",
|
| AGENT_NAME: SQL_PROCEDURE
|
|
);
|
|
T
1
.DEPENDS_ON_TASK.
T
2
(SUCCESS);
|
|
T
2
.DEPENDS_ON_TASK.
T
3
(ERROR);
|
|
MY_SCHEDULER.CREATE_SCHEDULER(
|
| LOAD_NAME: Test_load,
|
| CONTEXT_NAME: Test_context,
|
| DATE_TIME: "01.01.1970 00:00:00",
|
| DESCRIPTION: "Scheduler Service"
|
|
);
|
