TestSchedules Table

Applies to QAComplete 12.93 SaaS, last modified on November 01, 2021

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.

See Also

TestSchedules View
Test Management

Highlight search results