USP_EMAILJOB_ADDCONDITIONALCONTENTRECIPIENTS
Adds email job recipients for the specified job to the conditional content recipient table.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EMAILJOBID | int | IN |
Definition
Copy
CREATE procedure dbo.USP_EMAILJOB_ADDCONDITIONALCONTENTRECIPIENTS
(
@EMAILJOBID int
)
as
begin
insert into dbo.CONDITIONALCONTENTRECIPIENT (ID, EMAILJOBID, BOSPID, USERID, EMAILADDRESS)
select EJR.MERGEID, @EMAILJOBID, EJR.BACKOFFICESYSTEMPEOPLEID, case EJR.USERID when 0 then null else EJR.USERID end, EJR.EMAILADDRESS
from dbo.EMAILJOB_RECIPIENT EJR with (nolock)
where EJR.EmailJobID = @EMAILJOBID
order by EJR.EmailJobID;
end