Join Wintertainment 2021 to share your stories, have fun, earn community badges, and more!

TestSchedules View

Applies to QAComplete 12.94 SaaS, last modified on December 06, 2021

Description

Contains detailed information on test schedules.

Dependencies

Columns

Agents  :  nvarchar (max 2000 chars, or 4002 bytes), allows null: no

The test agent used on the test host (for example, TestComplete/TestExecute).

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 Text Feature.

Custom11..Custom90  :  varchar (max 100 chars), allows null: yes

The values of custom fields 11 through 90.

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.

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.

DateOpened  :  datetime, allows null: no

An alias for the DateCreated column of the TestSchedules table.

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.

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.

HostId  :  int, allows null: yes

The ID of the test host that is used for scheduled tests.

Id  :  int, allows null: no

The unique numeric identifier of the item.

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.

NbrFiles  :  int, allows null: no

The number of files attached to the test schedule.

NbrNotes  :  int, allows null: no

The number of notes attached to the test schedule.

OpenedByName  :  varchar (max 78 chars), allows null: yes

The name of the user who added the associated item, in the Last name, First name format.

OwnerName  :  varchar (max 78 chars), allows null: yes

The name of the user who owns the associated item, in the Last name, First name format.

OwnerUserId  :  int, allows null: no

An alias for the CreateUserId column of the TestSchedules table.

The ID of the user who created the schedule.

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.

UserName  :  varchar (max 78 chars), allows null: yes

The name of the user who last updated the associated item, in the Last name, First name format.

See Also

TestSchedules Table
Test Management

Highlight search results