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 user

Use this drop down list to choose the user or role for which you want to specify scheduled workbook settings. For example, choose jchan to display the scheduled workbooks 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 Chapter 6, "How to specify a user or role (responsibility) to perform a specific task":

Select user to own the tables which store the workbook results

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

Require users to schedule workbooks

• User must always schedule workbooks

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

• User is never required to schedule workbooks

  Use this radio button to enable users to choose whether or not they want to run queries using the scheduled workbooks facility.

• Schedule only if predicted time exceeds

  Use this radio button for users to schedule workbooks if the predicted time to run the query exceeds the value specified in the Minutes field.

Limit number of scheduled workbooks

Use this check box to specify the maximum number of workbooks that a user can schedule. Use this option to control the use of the DBMS_JOB queue and prevent system overload.

Expire results

Use this check box to limit the lifetime of scheduled workbook results. 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. On large result sets, server performance is improved by setting the commit size higher than the default.

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.