Profile Scheduler

The Profile Scheduler component in Spreadsheet Server allows for automating and/or scheduling various jobs, such as caching the Distribution Manager address book, refreshing workbooks, distributing Distribution Manager workbooks, loading custom tables or local database files, and running workbooks for Budget Accelerator writebacks, or Spreadsheet Analyst reporting. A user's ability to access Profile Scheduler, the Database Management tab within the component, and to create, edit, delete, and/or run a job determined by the user's Application Configurator settings.

Note: As Profile Scheduler works with the Windows Task Scheduler, if scheduling and running jobs, various user right assignments and set up conditions may be required based on the profile type and process (see Profile Scheduler Overview for more information.

Access Profile Scheduler

From the desktop, click Start > Programs > Spreadsheet Server Suite > Profile Scheduler. The Profile Scheduler panel appears.

Note: If Windows Single sign-on (SSO) is not enabled, the user is first prompted to sign into Spreadsheet Server.

Create a New Job

1. From the Profile Scheduler panel, select the Jobs tab.
2. To add a new job, select New. The Select Profile Type panel appears.

3. Click the drop-down list, select the desired profile type for which to create a new job, then click OK. The appropriate New Job panel appears.

Note: If the associated host configuration of a Load Local INF, or Load Local JD Edwards job uses <Sign-On>, the user is first prompted to sign into the database, if not already connected.

Use the following links to access specific profile type information:

• Address Book Cache
• Distribution Manager
• Custom Table Loads
• Load Local INF
• Load Local JD Edwards
• Workbook Automation

Note: Workbook Automation is only available if the user is licensed to both Spreadsheet Server and Budget Accelerator, or, if the user is licensed to Spreadsheet Analyst.

Maintain an Existing Job

1. From the Profile Scheduler panel, select the Jobs tab.
2. To modify an existing job, double-click the desired job in the list, or, select the desired job in the list, then, select Edit. The appropriate job panel appears.

Note: If the associated host configuration of a Load Local INF, or Load Local JD Edwards job uses <Sign-On>, the user is first prompted to sign into the database, if not already connected.

Run One or More Jobs

1. From the Profile Scheduler panel, select the Jobs tab.
2. To run one or more jobs, select the Run check box for the desired jobs in the list, if desired select the Halt On Error option indicating to stop all processing when an error occurs, then, from select Run. The system processes the jobs, and updates the Start, Finish, and Status fields accordingly.
Note:
• If the associated host configuration of a Load Local INF, or Load Local JD Edwards job uses <Sign-On>, the user is first prompted to sign into the database, if not already connected.
• If running a Distribution Manager job, and the user or connection is not Windows Single sign-on (SSO) enabled, the user is first prompted to sign into Spreadsheet Server.