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 parameter can be set in the Email activity, and saved to DPM. The table value takes precedence over any DPM settings. When empty, the query from the DPM properties (for the specified project and job) is used.
Datatype: nvarchar(MAX)
Allow nulls: no
ParticipantOrderBy
The SQL ORDER BY clause that is used to select participants. 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 order from the DPM properties (for the specified project and job) is used.
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