This section describes how Autoperf uses stored procedures to perform scheduled performance calculations. Autoperf uses three stored procedures:
...
- This stored procedure checks which Autoperf Profiles are set up for the entity.
It submits a Performance Calculation for any Autoperf Profile with a Frequency option of Daily or Monthly and that also has the Position check box selected.
NOTE: It does not run Profiles with a Frequency option of Monthly using Daily because the Hierarchy is not set (Hierarchy=-1).- The Performance Calculation report calculates and commits Daily or Monthly returns.
- Upon committing returns, the report calls the UPDATE_PERF_FEED_STATUS stored procedure with Type of Data Feed = "PERFORMANCE" and sets the Hierarchy (that is, the report rule ID).
...