AutomationSchedules View

Applies to QAComplete 12.71 SaaS, last modified on January 18, 2021

Description

Contains detailed information on automation schedules.

Dependencies

Columns

AutomationScheduleId  :  int, 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.

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

The name of the user who created the automation schedule.

ParentId  :  int, allows null: yes

The ID of the parent automation test item.

ParentName  :  nvarchar (max), allows null: yes

The name of the parent automation test item.

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.

SuitePath  :  nvarchar (max), allows null: yes

The full path to the test project.

TestName  :  nvarchar (max), allows null: yes

The name of the related automation test.

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.

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

The name of the user who last updated the automation schedule.

See Also

AutomationSchedules Table
Legacy Test Management

Highlight search results