AutomationSchedules Table

Applies to QAComplete 12.80 SaaS, last modified on April 20, 2021

Description

This table stores schedules of TestComplete tests created in the legacy Test Automation module. Schedules of tests created in the new Test Management module are stored in the TestSchedules table.

Columns

The table contains the following columns:

AutomationScheduleId  :  int, primary key, allows null: no

The unique numeric identifier of the automation schedule.

AutomationTestItemId  :  int, allows null: no

The ID of the related automation test.

CreateUserId  :  int, allows null: no

The ID of the user who created the item.

DateBegin  :  datetime, allows null: no

The start date and time of the automation schedule.

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 item 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 end date and time of the automation schedule.

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 item 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  :  smallint, allows null: yes

The number of days when the automation schedule should run.

ProjId  :  int, allows null: no

The ID of the project that contains the automation schedule.

Status  :  nvarchar (max 100 chars, or 202 bytes), allows null: yes

The status of the automation schedule.

TimeRun  :  nvarchar (max 100 chars, or 202 bytes), allows null: no

The time of the day when the schedule should run.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

See Also

AutomationSchedules View
Legacy Test Management

Highlight search results