TaskHistory

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

The TaskHistory class tracks Data Transformation Services (DTS) task execution and the outcome of the execution. It maintains a history of all the imports (and deletions) that have occurred within the Data Warehouse.

Data Members

Data member name

Data type

Default value

Description

CommerceSiteName

nvarchar(255)

None

None.

Description

nvarchar(255)

None

None.

DetailLevel

nvarchar(255)

None

None.

EndTime

datetime

None

None.

LogImportSubTaskID

int

None

None.

NumberOfTries

int

None

None.

OlapExport

smallint

None

None.

OperationDetailID

int

None

None.

OperationID

int

None

None.

PercentageComplete

int

0

Specifies the percentage of the Web Log Import tasks that is complete.

SourceInfo

nvarchar(255)

None

None.

StartTime

datetime

None

None.

Status

int

None

None.

TaskID

int

0

Stores the unique key for the object.

Class Key

TaskHistoryKey is composed of a single data member, TaskID.

Relations

For a description of the relation type, see Data Warehouse Classes.

Relation name

Parent

Child

Type

TaskHistoryBasket

TaskHistory

Basket

2

TaskHistoryCampaignEvent

TaskHistory

CampaignEvent

2

TaskHistoryFirstUriByDate

TaskHistory

FirstUriByDate

2

TaskHistoryHitsByHour

TaskHistory

HitsByHour

2

TaskHistoryHitsInfo

TaskHistory

HitsInfo

2

TaskHistoryLastUriByDate

TaskHistory

LastUriByDate

2

TaskHistoryLogImportJobSummaryRel

TaskHistory

LogImportJobSummary

2

TaskHistoryLogImportJobSubtaskRel

TaskHistory

LogImportSubtask

2

TaskHistoryOpenUserVisitRel

TaskHistory

OpenUserVisit

2

TaskHistoryOrder

TaskHistory

Order

2

TaskHistoryRequestByDateByUriByQueryString

TaskHistory

RequestByDateByUriByQueryString

2

TaskHistoryRequestRel

TaskHistory

Request

2

TaskHistoryVisitInfoRel

TaskHistory

VisitInfo

2

TaskHistoryVisitRel

TaskHistory

Visit

2

See Also

Other Resources

Data Warehouse Classes