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 VLOutgoingPropertiesadditional PUT command parameters/headers, for example, `Subject`. Note: All corresponding inserts into VLSend, VLOutgoing, andVLOutgoingProperties 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.

Related articles