EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB30775: How are time-based and event-based schedules executed in a clustered MicroStrategy Server environment?


Community Admin

• Strategy


An administrative task created using time-based schedule will still only run on the primary node. However, for tasks which are relevant to be performed on all nodes of a cluster such as deletion of caches, users can schedule an administrative task to be performed on all nodes of the cluster.

INTRODUCTION
Scheduling is a feature of Strategy Intelligence Server that can be used to automate various tasks. To use the this feature, a schedule must be created first.
 
A schedule is a Strategy object that contains information specifying when a task is to be executed. Schedules are stored at the project source level, and are available to all projects within the project source.
 
Strategy Intelligence Server supports two kinds of schedules:

  1. Time-triggered schedules execute at a specific date and time, or at a specific recurring date and time. These schedules execute based on the time on the machine where they were created.
  2. Event-triggered schedules execute when the event associated with them is triggered.

Both types of schedules can be used to schedule reports and documents, called subscriptions, or to schedule administrative tasks like delete all history list, idle project, etc.
For details on how to configure each type of schedule, refer to the System Administration Guide found under Strategy Product Manuals.
 
Execution of Time-Based Schedules in a Strategy Intelligence Server Cluster:
In a 9.x Strategy Intelligence Server clustered environment, subscriptions created using a time-based schedule will not be restricted to the primary node only. It will be load balanced across all nodes of the cluster.
 
An administrative task created using time-based schedule will still only run on the primary node. However, for tasks which are relevant to be performed on all nodes of a cluster such as deletion of caches, users can schedule an administrative task to be performed on all nodes of the cluster. Refer to the following Strategy Knowledge Base document for more information:
 
KB30866: New feature in MicroStrategy Intelligence Server 9.0: Schedule administrative tasks to be performed on all nodes of the cluster
 
Execution of Event-Based Schedules in a Strategy Intelligence Server Cluster:
In a 9.x and 10.x Strategy Intelligence Server clustered environment, subscriptions created using an event-based schedule will not be restricted to any particular node. They will be load balanced across all nodes of the cluster.
 
An administrative task created using an event-based schedule will still only run on node where the event is triggered. However, like time triggered schedules, using event based schedules, tasks which are relevant to be performed on all nodes of a cluster such as deletion of caches, can be scheduled to be performed on all nodes of the cluster or on the local node. See KB30866 for more details on how to do this.
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 12, 2017

Last Updated:

June 14, 2017