Alter Data Load Statement

This command modify the settings of an existing data load. The command will overwrite all the setting of the old data load with the new definition provided.

Copy

ALTER DATA LOAD “<name>” [NEW NAME “<new_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.
New name: The new name of the dataload.
Server name: The server that will be associated with this data load.
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 trigger.
Day of the week: Indicate in which day of the week the data load will be trigger.
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 enable or not.

Example

Copy

ALTER DATA LOAD "Data Load 1" ENABLED IN ENTERPRISE MANAGER "localhost" IN PORT 9999;