SendEmailTask table
The SendEmailTask table provides additional information that is required for a SendEmail task.
Columns
Id
Unique identifier for the table row.
Datatype: int
Allow nulls: no
Job
The email job name that is associated with this task.
Datatype: nvarchar(200)
Allow nulls: no
Project
The project name that is associated with the email task.
Datatype: nvarchar(200)
Allow nulls: yes
ParticipantSelectQuery
The SQL WHERE clause that is used to select participants. This ParticipantSelectQuery parameter is set in the Email activity, and saved to DPM. If a value is set in the table, the table value takes precedence over the DPM setting. When empty, the query from the DPM properties (for the specified project and job) is used.
This column is reserved for customization by customers or third parties. The column is empty when using standard UNICOM Intelligence activities.
Datatype: nvarchar(MAX)
Allow nulls: no
ParticipantOrderBy
The SQL ORDER BY clause that is used to select participants. This ParticipantOrderBy parameter is set in the Email activity, and saved to DPM. f a value is set in the table, the table value takes precedence over the DPM setting. When empty, the order from the DPM properties (for the specified project and job) is used.
This column is reserved for customization by customers or third parties. The column is empty when using standard UNICOM Intelligence activities.
Datatype: nvarchar(MAX)
Allow nulls: no
BatchSize
The number of emails to send each time the task is executed (at the specified RecurrenceInterval). This parameter can be set in the Email activity, and saved to DPM. The table value takes precedence over any DPM settings. When empty, the value from the DPM properties (for the specified project and job) is used.
Datatype: int
Allow nulls: no
See also