MicroStrategy ONE
Alter Schedule statement
Modifies the properties of a schedule.
ALTER SCHEDULE schedule_name [NAME new_schedule_name] [DESCRIPTION new_description] [LONGDESCRIPTIONlong_description] [STARTDATE new_start_date] [ENDDATE (new_end_date | NEVER)] [TYPE (EVENTTRIGGERED EVENTNAME new_event_name | TIMETRIGGERED (DAILY EVERY (new_number DAYS | WEEKDAY) | WEEKLY EVERY new_number WEEKS ON day_of_week1 [, day_of_week2 [,...day_of_week7]] | MONTHLY (DAY new_number OF EVERY new_number MONTHS | (FIRST | SECOND | THIRD | FOURTH | LAST) (day_of_week1 | day_of_week2 | ... | day_of_week7) OF EVERY new_number MONTHS) | YEARLY ((month_of_year1 | month_of_year2 | ... | month_of_year12) new_number | (FIRST | SECOND | THIRD | FOURTH | LAST) (day_of_week1 | day_of_week2 | ... | day_of_week7) OF (month_of_year1 | month_of_year2 | ... | month_of_year12))) [EXECUTE (newtime_of_day | ALL DAY EVERY (newnumber HOURS | newnumber MINUTES | newnumber HOURS newnumber MINUTES) [STARTTIME newtime_of_day] [ENDTIME newendtime_of_day]))];
where:
-
schedule_name is the name of the schedule to be altered, of type string, between double quotes (" ").
-
new_schedule_name is the new name of the schedule, of type string, between double quotes (" ").
-
new_description is the new description of the schedule, of type string, between double quotes (" ").
-
long_description is the new long description of the schedule, of type string, between double quotes (").
-
new_start_date is the new start date that determines the first day the schedule will be active, of type date (mm/dd/yyyy).
-
new_end_date is the new end date of the schedule, of type date (mm/dd/yyyy). The schedule will never be triggered again after this date.
-
new_event_name is the new name of the event to be linked to an event-triggered schedule, of type string, between double quotes (" "). The schedule is activated when this specific event occurs.
-
new_number is the new number of days, weeks, months, minutes, hours and day within a month, to be specified for a time-based schedule, of type integer.
-
day_of_weekn is the day of the week to be specified for a time-based schedule, from the following list: SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY.
-
month_of_yearn is the month of the year to be specified for a time-based schedule, from the following list: JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.
-
new_time_of_day is the new time of the day (24-hour format) to be specified for a time-based schedule, of type time (hh:mm).
-
newstarttime_of_day is the new time of the day (24-hour format) to be specified for starting a time-based schedule, of type time (hh:mm).
-
newendtime_of_day is the new time of the day (24-hour format) to be specified for ending a time-based schedule, of type time (hh:mm).
Example
ALTER SCHEDULE
"Schedule8" NAME "NewSchedule1" DESCRIPTION "1"
STARTDATE 09/10/2002 ENDDATE NEVER TYPE TIMETRIGGERED YEARLY LAST WEDNESDAY
OF MAY EXECUTE 15:30;