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.

Thanks

Shivmohan Purohit ———— share your feedback

Advertisements