A time range is a contiguous block of time within a single day across one or more contiguous days of the week. It is defined by its starting and ending periods.
Adaptive Server includes a predefined “at all times” range, which covers the period midnight through midnight, Monday through Sunday. You can create, modify, and drop additional time ranges as necessary for resource limits.
Named time ranges may overlap. However, the limits for a particular user/application combination cannot be associated with named time ranges that overlap. You can create different limits that share the same time range.
For example, assume that you limit “joe_user” to returning 100 rows when he is running the payroll application during business hours. Later, you attempt to limit his row retrieval during peak hours, which overlap with business hours. You see a message that the new limit failed, because it would have overlapped with an existing limit.
Although you cannot limit the row retrieval for “joe_user” in the payroll application during overlapping time ranges, you can put a second limit on “joe_user” during the same time range as the row retrieval limit. For example, you can limit the amount of time one of his queries can run to the same time range that you used to limit his row retrieval.
When you create a named time range, Adaptive Server stores it in the systimeranges system table to control when a resource limit is active. Each time range has a range ID number. The “at all times” range is range ID 1. Adaptive Server messages refer to specific time ranges.
