How to delete scheduled workbooks and results in Discoverer

hello dear friend,

Here is a very good piece on discoverer, how to know the results of schedule reports and insight into it

How to delete scheduled workbooks and results in Discoverer.


A scheduled workbook can be setup to run at a particular frequency, e.g. daily, weekly, etc., or it can be set to never repeat. When a workbook is scheduled the following database objects are created:


A view is created containing the select statement to create the result tables (e.g. EUL5_B011206161506Q1V1)


A table is created for each run with the results (e.g. EUL5_B011206161506Q1R1)


A package is created with the run information (e.g. EUL5_BATCH_PACKAGE011206161506 )


A job is created to call package at specified schedule intervals (e.g. EUL5_BATCH_PACKAGE011206161506.RUN)


All objects have the same unique sequence number in the name.  The R1 tables hold the results of a particular run of a scheduled workbook. A scheduled workbook can have a number of R1 tables, because a new table is created every time the scheduled workbook runs. If deleting the result sets for a scheduled workbook through the Discoverer Plus or Desktop then the R1 tables will be deleted from the database. If deleting the scheduled workbook from the Scheduling Manager then all the database objects will be deleted.


Shivmohan Purohit ———— share your feedback

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s