Admin_Script_Schedule_Map
This table is in the Script category (see Script). For database rules, see Script Tables.
Each row describes the schedule associated with an administrative script.
Use the Administrative Manager facility of the Script Editor to add, update, and delete Admin_Script_Schedule_Map records.
Related tables
-
Master_Script (through MasterScriptID)
index_name |
index_description |
index_keys |
---|---|---|
XPKAdmin_Script_Schedule_Map |
Primary key |
MasterScriptID, SequenceNumber |
Name |
Description |
Data Type |
Keys and NULL Option |
---|---|---|---|
DayFlags |
A bitmask specifying the days on which the script is executed. To see values, see Days. |
DBINT |
NOT NULL |
DayOfMonth |
Indicates to which day of month the schedule applies. To see values, see Days. |
DBSMALLINT |
NOT NULL |
DayPosition |
In conjunction with DayType, the position of a day within a month. To see values, see Days. |
DBSMALLINT |
NOT NULL |
DayType |
Indicates to which day the schedule applies. To see values, see Days. |
DBSMALLINT |
NOT NULL |
Description |
Additional information about the schedule. |
DESCRIPTION |
NULL |
EndDay |
The day of the month on which the schedule expires. The value is 0 if the schedule has no end date. |
DBSMALLINT |
NOT NULL |
EndHour |
The hour of the day at which the schedule expires. The value is 0 if the schedule has no end time. |
DBSMALLINT |
NOT NULL |
EndMinute |
The minute of the hour at which the schedule expires. The value is 0 if the schedule has no end time. |
DBSMALLINT |
NOT NULL |
EndMonth |
The month in which the schedule expires. The value is 0 if the schedule has no end date. |
DBSMALLINT |
NOT NULL |
EndSecond |
The second of the minute at which the schedule expires. The value is 0 if the schedule has no end time. |
DBSMALLINT |
NOT NULL |
EndYear |
The year in which the schedule expires. The value is 0 if the schedule has no end date. |
DBINT |
NOT NULL |
MasterScriptID |
The scheduled administrative script. |
DBINT |
PK, FK NOT NULL |
MonthOfYear |
Indicates to which month the schedule applies:
|
DBSMALLINT |
NOT NULL |
Recurrence |
The granularity of the script frequency interval:
|
DBSMALLINT |
NOT NULL |
RecurrenceFreq |
Specifies how many recurrence intervals occur between successive executions. |
DBINT |
NOT NULL |
SequenceNumber |
Index for schedules associated with a specific master script. |
DBINT |
PK NOT NULL |
StartDay |
The day of the month on which the schedule goes into effect (1 through 31). |
DBSMALLINT |
NOT NULL |
StartHour |
The hour of the day at which the schedule goes into effect. |
DBSMALLINT |
NOT NULL |
StartMinute |
The minute of the hour at which the schedule goes into effect. |
DBSMALLINT |
NOT NULL |
StartMonth |
The month in which the schedule goes into effect (1 through 12). |
DBSMALLINT |
NOT NULL |
StartSecond |
The second of the minute at which the schedule goes into effect. |
DBSMALLINT |
NOT NULL |
StartYear |
The year in which the schedule goes into effect |
DBINT |
NOT NULL |
Type |
The type of schedule. |
DBSMALLINT |
NOT NULL |