Profile Scheduler Overview
The Profile Scheduler component in Spreadsheet Server allows for scheduling various jobs, such as caching the Distribution Manager address book, refreshing workbooks, distributing Distribution Manager workbooks, loading local database files, and running workbooks for Budget Accelerator writebacks, or Spreadsheet Analyst reporting.
Available profile types include:
- Address Book Cache: caches the address book lists used in Distribution Manager in order to reduce the time required to load the email address book.
- Distribution Manager: refreshes selected workbooks with specified replacement values and/or distributes selected Distribution Manager workbooks.
- Custom Table Loads: downloads tables and table data from a source database into a target database, allowing for optimized calculation speeds.
- Load Local Database Files: downloads account balance information into local databases, allowing for optimized calculation speeds. This is an excellent option for producing Spreadsheet Server reports once books have been closed and the analytical tasks have been performed in real time. The time spent loading the local databases is greatly offset by the dramatically reduced spreadsheet calculation times.
- Workbook Automation: processes writebacks for Budget Accelerator workbooks, or performs workbook generation for Spreadsheet Analyst reports.
As Profile Scheduler works with the Windows Task Scheduler, use the below table for required user right assignments:
| Profile Type | Creating and Manually Running a Job, or Scheduling a Job, or Running a Scheduled Job While Logged in |
While Logged in and Running a Job Under Another Account |
|---|---|---|
Address Book Cache, Custom Table Loads, or Load Local |
No special requirements |
Administrator privileges |
Distribution Manager, Workbook Automation |
No special requirements |
Not applicable |
- To verify if a user is part of the Administrator group:
- Navigate to Control Panel > Administrative Tools > Computer Management.
- From the Computer Management tree, navigate to Local Users and Groups > Groups.
- Double-click Administrators to view the properties.
- Verify that the user is in the group, or add the user to the group if necessary.
- Mapped drives used in any part of the Profile Scheduler process, including Distribution Manager (for example, the file save folder) or Spreadsheet Server (for example, file locations), must be defined in the Mapped Drives tab when running and scheduling a job for certain profile types.