MicroStrategy ONE

Time-Triggered Schedules

With a time-triggered schedule, you define a date and time at which the scheduled task is to be run. For example, you can execute a task every Sunday night at midnight. Time-triggered schedules are useful to allow large, resource-intensive tasks to run at off-peak times, such as overnight or over a weekend.

  • Time-triggered schedules execute according to the time on the machine where they were created. For example, a schedule is created using Developer on a machine that is in the Pacific time zone (GMT -8:00). The schedule is set to be triggered at 9:00 AM. The machine is connected to an Intelligence Server in the Eastern time zone (GMT -5:00). The schedule executes at 12:00 PM Eastern time, which is 9:00 AM Pacific time.
  • In a clustered environment, administrative tasks associated with time-triggered schedules are executed on only the primary node of the cluster.