EVENT_STATUS
The EVENT_STATUS is inserted and updated by the application and contains current status of all events. The EVENT_STATUS record will be created once a job has been inserted into OUT_EMAIL, OUT_FAX, OUT_PRINT or OUT_FILE. Records may not be inserted into this table.
Column | Type | Values | Comments |
gKey | Uniqueidentifier | ||
jKey | Uniqueidentifier | ||
Run_When | Datetime | The value in this field determines when the event will be carried out. To defer a job to a future date this field may be set with an update to a future date and time. | |
Retry_Times | Integer | The value controls how many times retry attempts that should be made when using e-mail services. The default value of this is set during the setup. | |
Retry_Period | Integer | Seconds | The value controls the interval between retry attempts.The default value of this is set during the setup. |
Tried_Times | Integer | This field is updated by Boomerang shows how my attempts sending an e-mail have been made | |
Status | Text | 0 = Ready/Pending1 = Completed Successfully2 = Completed with errors3 = In Progress | See the EVENT_LOG section for more information on message types. |
Closed | 0 = Open1 = Closed | ||
Processed_On | Datetime | Automatic date stamp indicating last processed date and time. |