MicroStrategy - Command Manager - Schedules

mstr
Command Manager

How can we list properties for a particular schedule?

LIST PROPERTIES FOR SCHEDULE "Schedule1";

How can we list all schedules?

LIST ALL SCHEDULES;

How can we alter a particular schedule?

ALTER SCHEDULE "1. Daily"     TYPE TIMETRIGGERED  DAILY EVERY WEEKDAY EXECUTE 03:00;
ALTER SCHEDULE "2. Weekly"     TYPE TIMETRIGGERED  WEEKLY EVERY 1 WEEKS ON MONDAY   EXECUTE 03:00;
ALTER SCHEDULE "3. Monthly"     TYPE TIMETRIGGERED  MONTHLY DAY 3 OF EVERY 1 MONTHS  EXECUTE 03:00;
ALTER SCHEDULE "4. Quarterly"     TYPE TIMETRIGGERED  MONTHLY  DAY 3 OF EVERY 3 MONTHS  EXECUTE 03:00;
ALTER SCHEDULE "Schedule7" 
    NAME "NewSchedule1" 
    DESCRIPTION "1" 
    STARTDATE 09/10/2010 
    ENDDATE NEVER 
    TYPE TIMETRIGGERED 
    YEARLY LAST WEDNESDAY OF MAY EXECUTE 15:30;

How can we delete a particular schedule?

DELETE SCHEDULE "Schedule4";

How can we create a schedule that is triggered by an event?

CREATE SCHEDULE "Database Load" 
    STARTDATE 09/10/2010 
    ENDDATE NEVER 
    TYPE EVENTTRIGGERED 
    EVENTNAME "Books Closed";

How can we create a daily schedule?

CREATE SCHEDULE "Schedule1" 
    STARTDATE 09/10/2010 
    ENDDATE NEVER 
    TYPE TIMETRIGGERED 
    DAILY EVERY 5 DAYS EXECUTE 10:00;

The above statement create a scheduled that is "time triggered" daily, and run every 5 days, and execute at 10:00.

CREATE SCHEDULE "Schedule2" 
    STARTDATE 09/10/2010 
    ENDDATE NEVER 
    TYPE TIMETRIGGERED 
    DAILY EVERY WEEKDAY 
    EXECUTE ALL DAY EVERY 5 MINUTES;
CREATE SCHEDULE "Schedule3" 
    STARTDATE 09/10/2010 
    ENDDATE NEVER 
    TYPE TIMETRIGGERED 
    WEEKLY EVERY 5 WEEKS ON MONDAY, TUESDAY, WEDNESDAY EXECUTE 18:00;
CREATE SCHEDULE "Schedule4" 
    STARTDATE 09/10/2010 
    ENDDATE 09/27/2017 
    TYPE TIMETRIGGERED 
    MONTHLY DAY 3 OF EVERY 5 MONTHS 
    EXECUTE ALL DAY EVERY 5 HOURS STARTTIME 00:00 ENDTIME 23:59;
CREATE SCHEDULE "Schedule5" 
    STARTDATE 09/10/2010 
    ENDDATE NEVER 
    TYPE TIMETRIGGERED 
    MONTHLY FIRST THURSDAY OF EVERY 10 MONTHS EXECUTE 13:00;
CREATE SCHEDULE "Schedule6" 
    STARTDATE 09/10/2010 
    ENDDATE NEVER 
    TYPE TIMETRIGGERED 
    YEARLY MARCH 10 EXECUTE 17:00;
CREATE SCHEDULE "Schedule7" 
    STARTDATE 09/10/2010 
    ENDDATE NEVER 
    TYPE TIMETRIGGERED 
    YEARLY SECOND SATURDAY OF MAY EXECUTE 09:00;
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License