Sending database payload

End user/application VersaLex
  • End user reviews settings in the VLOptions table.
  • End user application inserts into VLSend table SendID, Host, Mailbox, and InsertedDT columns and VLOutgoing table SendID, Fileindex, and Payload columns.  VLOutgoing table ExternalID, Filename, ContentType, and Filesize columns are optional.  Also, optionally, insert into VLOutgoingProperties additional PUT command parameters/headers, for example, Subject.
    Note: All corresponding inserts into VLSend, VLOutgoing, and VLOutgoingProperties tables must be committed to the database together.
 
 
  • VersaLex polls VLSend table for new outgoing payload.
  • While sending, VersaLex updates VLSend table SendingDT, LastAttemptDT, Retries, and TotalAttempts columns and VLOutgoing table TransferID, VLSerial, and MessageID columns.
  • The number of send retries and retry restart are controlled by the general VersaLex properties “Autosend Retry Attempts" and "Autosend Restart".  These can be set via the VersaLex UI at Configure > Options > Other.
  • If desirable, end user application can poll VLSend table for payload that is either not being attempted (InsertedDT >= 5 minutes ago and TotalAttempts = 0) or has repeatedly failed to be sent (TotalAttempts > 4) or has stopped trying (FinalAttemptDT != NULL).
 
 
  • After successfully sent, VersaLex either deletes VLSend and VLOutgoing rows if VLOptions table ClearSuccessfulSends column is true or sets the VLSend table SentDT column.