|
|
|
|
vEventInstanceDetail |
Provides a description of an event instance that was triggered. |
|
Column Name |
Type |
Purpose |
PartitionId |
numeric(26,0), not null |
Tenant identifier |
ScheduledDate |
datetime(3), not 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 |
bit, not null |
If event is running (in progress) |
CompletedWithErrors |
bit, not 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 endpoing 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 PW (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), not 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. |
powerUpIfOffline |
char(1), null |
If true, machine is powered up |
skipIfOffline |
char(1), null |
If true, machine is skipped if offline |
runAfterNextReboot |
char(1), null |
If true, run after reboot |
orgCalendarScheduleId |
numeric(26,0), null |
Associated ID in orgCalendarSchedule |