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.
Info 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).
...
- The 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, Monthly, or Monthly using Daily and that also has both the Position check box and Performance check box selected.
Info NOTE: It runs Monthly using Daily because the Hierarchy is set (Hierarchy not -1).