MicroStrategy ONE

Alter Schedule statement

Modifies the properties of a schedule.

Copy 
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

Copy 
ALTER SCHEDULE 
 "Schedule8" NAME "NewSchedule1" DESCRIPTION "1" 
 STARTDATE 09/10/2002 ENDDATE NEVER TYPE TIMETRIGGERED YEARLY LAST WEDNESDAY 
 OF MAY EXECUTE 15:30;