vEventInstanceHistoryDetail
|
vEventInstanceHistoryDetail |
Provides a history of event instances that were triggered. |
|
|
Column Name |
Type |
Purpose |
|
PartitionId |
numeric(26,0), null |
Tenant identifier |
|
ScheduledDate |
datetime(3), null |
Date/time instance was scheduled |
|
StartedDate |
datetime(3), null |
Date/time instance was started (running) |
|
CompletedDate |
datetime(3), null |
Date/time instance completed running |
|
InProcess |
int(10), not null |
If event is running (in progress) |
|
CompletedWithErrors |
bit, null |
If completed with errors |
|
EventTypeDesc |
varchar(256), not null |
Description |
|
IntervalTypeDesc |
varchar(50), not null |
Interval type ID |
|
EventDesc |
varchar(256), not null |
Description |
|
EventEndpoint |
varchar(770), not null |
The endpoint name to dispatch |
|
Data |
varchar(-1), null |
Data payload |
|
DataFileSpec |
varchar(200), null |
File path to pass along (if any) |
|
EffectiveDate |
datetime(3), not null |
Date event was first introduced |
|
ExpirationDate |
datetime(3), null |
Expiration date (if any) |
|
IntervalIncrement |
int(10), null |
Increment integer |
|
CreateOwnerCalendarEntries |
bit, null |
Boolean if year? worth of instances are forward created or not |
|
NotifyOwnerOnStartAndCompletion |
bit, not null |
Boolean notification flag (future use) |
|
NotifySubscribersOnCompletion |
bit, not null |
Boolean notification flag (future use) |
|
OwnerUserName |
varchar(50), null |
User Name |
|
OwnerCoveredPassword |
varchar(50), null |
Covered password (future use) |
|
StartNotificationNote |
varchar(100), null |
Notification note (future use) |
|
CompletionNotificationNote |
varchar(100), null |
Completion note (future use) |
|
SuspenseIntervalTypeID |
int(10), null |
Suspense interval type as specified in interval type ID table |
|
SuspenseIntervalIncrement |
int(10), null |
Suspense interval increment |
|
SuspenseExpirationEventID |
int(10), null |
Upon suspense expiration which event to dispatch (future use) |
|
SuspenseExpirationNote |
varchar(100), null |
Suspense expiration note (future use) |
|
ErrorEventID |
int(10), null |
Upon error, which event to dispatch (future use) |
|
ErrorNote |
varchar(100), null |
Error note (future use) |
|
PreparationEventID |
int(10), null |
(future use) |
|
PreparationEventData |
varchar(200), null |
(future use) |
|
EventInstanceID |
numeric(18,0), null |
Event instance unique ID |
|
SuspenseDate |
datetime(3), null |
Event suspense date |
|
CalendarEntriesAllowed |
bit, not null |
Should year? instance creation be allowed |
|
DefaultEventEndpoint |
varchar(770), not null |
Default endpoint name |
|
OwnerNotificationAllowed |
bit, not null |
Notification bit for owner |
|
SubscriberNotificationAllowed |
bit, not null |
Notification bit for subscriber |
|
SysMinIncrement |
int(10), not null |
Minimum increment |
|
SysMaxIncrement |
int(10), not null |
Maximum increment |
|
EventId |
int(10), not null |
Unique event type ID |
|
Active |
bit, not null |
Is active bit |
|
ErrorMessage |
varchar(500), null |
Error message (if any) |
|
InstanceData |
varchar(-1), null |
Data payload |
|
ConfiguredRunCount |
int(10), null |
Run count (number of times) |
|
CurrentRunCount |
int(10), null |
Run count (number of times) |
|
InstanceRunCount |
int(10), null |
Run count (number of times) |
|
ScriptId |
int(10), null |
script ID linking to agent procedures |
|
AgentGuid |
numeric(26,0), null |
Unique 26 digit random number identifying this agent. Master record stored in machNameTab. |
|
orgCalendarScheduleId |
numeric(26,0), null |
Associated ID in orgCalendarSchedule |
