USP_EMAILJOBDATALIST
Returns list of prepared merge data to be submitted to email shared services.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EMAILJOBID | int | IN |
Definition
Copy
CREATE procedure dbo.USP_EMAILJOBDATALIST(@EMAILJOBID integer)
as
set nocount on;
select ID
from dbo.EMAILJOBDATA
where EMAILJOBID = @EMAILJOBID and SENT = 0 AND RECIPIENTCOUNT > 0