TaskHistory
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 |