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?"
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.
Use this check box to display scheduled workbooks for all users.
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.
This read-only field displays any additional information about the selected workbook.
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.
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.
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.
Use this button to check the database for any changes to the schedule since you opened this dialog.
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.