MicroStrategy ONE

Scheduling Administrative Tasks

In addition to scheduling reports and documents execution, you can instruct Intelligence Server to perform certain administrative tasks according to a schedule. For example, you can delete all History List messages every month, or idle a project once a week for maintenance and then resume it an hour later.

To schedule an administrative task, you must have the Administer Subscriptions privilege and any privileges required for that task.

To Schedule an Administrative Task

  1. In Developer, from the Administration menu, point to Scheduling and then select Schedule Administration Tasks.
  2. To schedule tasks for a project, select that project. To schedule tasks for the project source, select All Projects.
  3. Choose a task from the action list. For descriptions of the tasks, see the table below.
  4. Select one or more schedules for the task.
  5. Set any additional options required for the task.
  6. Click OK.

The table below lists the tasks that can be scheduled for a project. Some of the tasks can also be scheduled at the project source level, affecting all projects in that project source.

Task

Description

Cache or History List management tasks

Delete caches

Delete all report caches for the project. For more information, see Managing Result Caches.

Typically the Invalidate Caches task is sufficient to clear the report caches.

Clean History List database

Delete orphaned entries and ownerless inbox messages from the History List database. For more information, see Managing History Lists

Delete History List messages (project or project source)

Delete all history list messages for the project or project source. For more information, see Managing History Lists.

This maintenance request can be large. Schedule the History List deletions for times when Intelligence Server is not busy, such as when users are not sending requests to the system. Alternatively, delete History Lists in increments; for example, delete the History Lists of groups of users at different times, such as at 1 AM, 2 AM, and so on.

Invalidate caches

Invalidate the report caches in a project. The invalid caches are automatically deleted once all references to them have been deleted. For more information, see Managing Result Caches.

Purge element caches

Delete the element caches for a project. For more information, see Deleting All Element Caches.

Intelligent Cube management tasks

Activate Intelligent Cubes

Publish an Intelligent Cube to Intelligence Server, making it available for use in reports. For more information, see Managing Intelligent Cubes.

Deactivate Intelligent Cubes

Unpublish an Intelligent Cube from Intelligence Server. For more information, see Managing Intelligent Cubes.

Delete Intelligent Cube

Delete an Intelligent Cube from the server. For more information, see Managing Intelligent Cubes.

Update Intelligent Cubes

Update a published Intelligent Cube. For more information, see Managing Intelligent Cubes.

Project management tasks

Idle project

Cause the project to stop accepting certain types of requests. For more information, see Setting the Status of a Project.

Load project

Bring the project back into normal operation from an unloaded state. For more information, see Setting the Status of a Project.

Resume project

Bring the project back into normal operation from an idle state. For more information, see Setting the Status of a Project.

Unload project

Take a project offline to users and remove the project from Intelligence Server memory. For more information, see Setting the Status of a Project.

Miscellaneous management tasks

Batch LDAP import (project source only)

Import LDAP users into the MicroStrategy system. For more information, see Manage LDAP Authentication.

Delete unused managed objects (project or project source)

Remove the unused managed objects created for Freeform SQL, Query Builder, and MDX cube reports. For more information, see Delete Unused Schema Objects: Managed Objects.

Deliver APNS Push Notification

Deliver a push notification for a Newsstand subscription to a mobile device. For more information, see the MicroStrategy Mobile Design and Administration Guide.