Scheduling Workbooks in Discoverer.

Discoverer workbooks can be scheduled at a specified time and frequency in the database. There are two main reasons for scheduling a workbook.

The workbooks which are regularly used in business can be scheduled to minimize manual intervention.
The workbooks which are complex and takes long time to complete can be scheduled to run at off-pick times. It will certainly avoid overburdening the server during the peak times.
Who can schedule a workbook?

You must have the required privileges to schedule workbooks. Contact your Discoverer Administrator for more details. Also you can only edit scheduled workbooks that you create yourself (using your current Discoverer user name).
Scheduling a workbook in Discoverer

When you create a new workbook, you can schedule it when you want to process the workbook at a particular time and frequency. Do the following steps to schedule a workbook:

1] Open the workbook.
2] Go to File > Schedule

• Define a name for the scheduled workbook. 
• Define a description for the scheduled workbook. 
• Specify which worksheets you want to schedule.

3] (Optional) If parameters are required for the worksheets, use the

 “Schedule Wizard: Parameter Values dialog” page(s) to enter required parameter 

values.

4] Use the “Schedule Wizard: Schedule dialog” page to specify when the scheduled 

workbook results are produced and how frequently they are produced.

5] Click Finish to create the scheduled workbook.
You can also schedule workbooks via Scheduling Manager.
Go to File > Manage Workbooks > Scheduling Manager

You can also do the below actions via Scheduling Manager:

• Edit a scheduled workbook 
• Delete scheduled workbook results 
• Unscheduled a workbook 

How to view scheduled workbook results? 

Scheduled workbook results can be viewed in Discoverer Plus or Discoverer Viewer. 

When you connect to Discoverer, you are alerted when scheduled workbook results

 have been processed

 and are ready to open. 

How Discoverer process your scheduled workbooks? 

Discoverer processes scheduled workbooks as follows:
When workbooks are scheduled, the workbook processing is done automatically in the database.
You do not need to have Discoverer Plus running or connected to process scheduled workbooks.
Scheduled workbook results are saved in the database and are available when you start Discoverer.

Challa.