Description
This table stores schedules for automated tests created in Test Management. Schedules created in Test Automation (legacy) are stored in the AutomationSchedules table.
Columns
The table contains the following columns:
Id : int, primary key, allows null: no
The unique numeric identifier of the item.
HostId : int, allows null: yes
The ID of the test host that is used for scheduled tests.
Agents : nvarchar (max 2000 chars, or 4002 bytes), allows null: no
The test agent used on the test host (for example, TestComplete/TestExecute).
CreateUserId : int, allows null: no
The ID of the user who created the schedule.
Custom1..Custom10 : nvarchar (max), allows null: yes
The values of custom fields 1 - 10.
These columns correspond to fields that can be available for rich editing.
DateBegin : datetime, allows null: yes
The date when the schedule starts working.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateCreated : datetime, allows null: no
The date and time when the schedule was created.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateEnd : datetime, allows null: yes
The date when the schedule stops working.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateUpdated : datetime, allows null: no
The date and time when the schedule was last updated.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DaysRun : nvarchar (max 100 chars, or 202 bytes), allows null: no
The days of the week when the tests should be run.
IsActive : varchar (max 1 char), allows null: no
Indicates whether the schedule is enabled.
LastScheduleDate : datetime, allows null: yes
The date and time when the schedule was last run.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
ProjId : int, allows null: no
The ID of the project that contains the test schedule.
TimeRun : nvarchar (max 100 chars, or 202 bytes), allows null: no
The time when the tests should be run.
Title : nvarchar (max 255 chars, or 512 bytes), allows null: yes
The title of the test schedule.
UpdateUserId : int, allows null: no
The ID of the user who last updated the schedule.