systhresholds  systransactions

Chapter 1: System Tables

systimeranges

master database only

Description

systimeranges stores named time ranges, which are used by Adaptive Server to control when a resource limit is active.

Columns

The columns for systimeranges are:

Name

Datatype

Description

name

varchar(255)

Unique name of the time range.

id

smallint

Unique identifier for the time range. 1 represents the “at all times” limit.

startday

tinyint

Day of week (1 – 7) for the beginning of the range. Monday = 1, Sunday  = 7.

endday

tinyint

Day of week (1 – 7) for the end of the range. Monday = 1, Sunday = 7.

starttime

varchar(10)

Time of day for the beginning of the range.

endtime

varchar(10)

Time of day for the end of the range.

Indexes





Copyright © 2005. Sybase Inc. All rights reserved. systransactions

View this book as PDF