SendEmailTask table
The SendEmailTask table provides additional information that is required for a SendEmail task.
SendEmailTask table
Id
Datatype: int
Allow nulls: no
Unique identifier for the table row.
Job
Datatype: nvarchar(200)
Allow nulls: no
The email job name that is associated with this task.
Project
Datatype: nvarchar(200)
Allow nulls: yes
The project name that is associated with the email task.
ParticipantSelectQuery
Datatype: nvarchar(MAX)
Allow nulls: no
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.
ParticipantOrderBy
Datatype: nvarchar(MAX)
Allow nulls: no
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.
BatchSize
Datatype: int
Allow nulls: no
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.
See also