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"

Show scheduling limits for

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 capability, see Chapter 7, "How to specify a user or role (responsibility) to perform a specific task":

Select the user to own the results tables created in the database

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

Always

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

Never

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

If predicted time exceeds

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

Maximum limit 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 after

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.

Query schedule must start between

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.