Privileges dialog: Scheduled Workbooks tab

Use this tab to specify scheduled workbook settings for a specified user or role (role is replaced by responsibility for Oracle Applications users). For example, to limit the number of workbooks that a user can schedule, or to define the expiry date of scheduled workbooks.

For more information, see:

"Scheduling Workbooks"

"About Discoverer and security"

"How to set scheduled workbook limits"

Show scheduling limits 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 scheduling limits you want to change. For example, choose jchan to display the scheduled workbook settings for jchan.

Note: If you select a user or role that does not have schedule workbook privileges, the configuration details are disabled. If you want the user or role to have this privilege, see "How to specify a user or role (responsibility) to perform a specific task":

Select the user to own the tables which store any workbook results

Use this drop down list to select the user name of the database user that will own the scheduled workbooks tables.

<Is user required to schedule workbooks?>

Use these options to specify if or when a user is required to schedule workbooks.

  • User must always schedule workbooks

    Use this option for a Discoverer end user only to run queries using the scheduled workbooks facility.

  • User is never required to schedule workbooks

    Use this option to enable users to choose whether they want to run queries using the scheduled workbooks facility.

  • Schedule only if predicted time exceeds (HH:MM:SS)

    Use this option for users to schedule workbooks if the predicted time to run the query exceeds the value specified in the Time field. The maximum value that you can enter here is 23:59:59.

Limit number of scheduled workbooks

Use this check box to specify the maximum number of workbooks that a user can schedule.

Note: This option enables you to prevent users from submitting so many scheduled workbooks that no other jobs on the DBMS_JOB queue can run

Expire results

Use this check box to limit the lifetime of scheduled workbook results (days). Results due for deletion are deleted when the user disconnects from the EUL.

Commit size

Use this check box to specify the number of rows that are committed to the result table at a time, when Discoverer processes the scheduled workbook. For example, if 1000 rows need to be written and the Commit size is 100, 10 writes are performed. On large result sets, server performance is improved by setting the commit size higher than the default (although little gain will be achieved by setting the Commit size higher than 1000).

Restrict the hours during which a workbook may be scheduled

Use this check box to specify when a user can schedule workbooks. This could be exploited to prevent users from scheduling workbooks at peak times.