Create Data Load Statement

This command will create a data load object in the Enterprise Manager service.

Copy

CREATE DATA LOAD “<name>” FOR ENVIRONMENT “<server_name>” AND PROJECT “<project_name>” [, ENVIRONMENT “<server_name>” AND PROJECT “<project_name>” ...] DO ACTION [UPDATEWAREHOUSE] [CLOSESESSIONS] [REPOPULATETABLES] [UPDATESTATS] [UPDATEOBJECTDELETIONS] BEGIN DATE <date> [TO <date>] FREQUENCY (DAILY | WEEKLY | MONTHLY) ON [MONDAY] [TUESDAY] [WEDNESDAY] [THRUSDAY] [FRIDAY] [SATURDAY] [SUNDAY] FROM <time> TO <time> EVERY <number> (MINUTES | HOURS) (ENABLE | DISABLED) IN ENTERPRISE MANAGER “<em_machine>” IN PORT <port>;

where:

Name: The data load name.
Server name: The server that will be associated with this data load. This server should previously be added to Enterprise Manager using the Start Monitoring command.
Project name: Specifies the project which data will be used.
Actions: The actions this data load will trigger.
Begin date: The start date in which this data load becomes active.
End date: After this date the data load can no longer be executed.
Frequency: How often the data load will be triggered.
Day of the week: Indicate in which day of the week the data load will be triggered.
Start time: The start time of the data load in a 24 hrs format.
End time: The end of the time frame for execution in 24 hrs format.
Number of minutes or hours: The number of minutes or hours each execution is separated by.
Enable: If the data load is enabled or not.

Example

Copy

CREATE DATA LOAD "Data Load 1" FOR ENVIRONMENT "server1" AND PROJECT "MicroStrategy Tutorial", ENVIRONMENT "server2" AND PROJECT "MicroStrategy Tutorial" DO ACTION UPDATEWAREHOUSE CLOSESESSIONS UPDATEOBJECTDELETIONS BEGIN DATE "10/22/2015 22:00:00 +0000" TO "10/25/2015 22:00:00 +0000" FREQUENCY WEEKLY ON SATURDAY SUNDAY FROM 02:00:00 TO 06:00:00 EVERY 2 HOURS ENABLED IN ENTERPRISE MANAGER "localhost" IN PORT 9999;