Manage Scheduled Workbooks dialog

Use this dialog to monitor and maintain workbooks that Discoverer end users have scheduled. For example, you might want to check on the progress of a workbook being processed, or to remove a scheduled workbook that was created by a Discoverer end user but is no longer required.

For more information, see:

"What are workbooks and scheduled workbooks?"

Show workbooks for

Use the Select button next to this field to display the "Select User/Role dialog" where you can search for and select the user or role whose scheduled workbooks you want to view or edit. For example, choose jchan to display the scheduled workbooks for jchan.

Select all users

Use this check box to display scheduled workbooks for all users.

Scheduled workbooks

This field displays a list of the scheduled workbooks that are owned by the selected user or role. The workbooks listed are either scheduled to run or have already run and are ready to use. The list contains the following fields:

• User

  This column displays the name of the Discoverer user who scheduled the workbook.

• Name

  This column displays the name of the scheduled workbook.

• Status

  This column displays the status of the workbook. See the table below for information about the status of a workbook.

  Status	Description:
  Scheduled	This workbook has been scheduled and will run at the specified date and time.
  Running Query	This workbook is currently running. No results are available.
  Could not schedule	This workbook was not successfully submitted to the processing job queue. It is a good idea to let the Discoverer end user know so they can attempt to reschedule this workbook.
  Error while running query	There was an error when this workbook was run. No results were returned from the database. This could be due to a problem in the PL/SQL generation or execution. An Oracle database error is generated here and can be accessed by the database administrator. If part of a scheduled workbook fails (that is, one sheet out of the workbook), the entire scheduled workbook run fails.
  Report deleted by Administrator	The Discoverer manager has set the scheduled workbook for deletion. Report runs with this status are deleted when the user next disconnects from the EUL.
  EUL has changed, reschedule report	A change has occurred in the EUL which affects the scheduled workbook. For example, if a folder has been deleted. The user can resubmit the scheduled workbook.
  Number of Rows Limit exceeded	The results of this scheduled workbook return more rows than this user is allowed to retrieve. The results have been deleted. Use the "Privileges dialog: Query Governor tab" to change this limit.
  Report Expired	The expiration date has passed. This workbook is no longer available. Reports with this status are deleted when the user disconnects from the EUL.
  Report Ready	This workbook successfully queried the database and users can view the results.

  
  

• Date

  This column displays the date on which the workbook is next scheduled to run (if the workbook's status is Scheduled) or when the workbook was last run (if the workbook's status is Report Ready).

• Time

  This column displays the time at which the workbook is next scheduled to run (if the status is Scheduled) or was last run (if the status is Report Ready).

• Run time

  This column displays the length of time this workbook took to run.

Description

This read-only field displays any additional information about the selected workbook.

Edit

Use this button to display the "Schedule Workbook dialog: General tab", where you change the settings for the selected workbook. This option is only available for workbooks that have not yet been processed.

View Error

Use this button to display a description of why a selected workbook could not be run successfully. This option is only available for workbooks that could not be scheduled due to an error.

Unschedule/Delete

Use this button to un-schedule the workbook and remove the workbook from the list in the Scheduled workbooks field. Any workbooks resulting from previous runs of this workbook are removed.

Refresh

Use this button to check the database for any changes to the schedule since you opened this dialog.

Notes

• You can re-sort the Scheduled Workbooks list by clicking the column you want to sort by. For example, if you want the list sorted by date, click the Date column header.