USP_EMAILJOB_ADDCONDITIONALJOB

Adds conditional content email job based on the specified parent job.

Parameters

Parameter	Parameter Type	Mode
@PARENTJOB	int	IN
@JOBKEY	nvarchar(1000)	IN
@NAME	nvarchar(50)	IN
@CONTENTHTML	nvarchar(max)	IN
@CONTENTTEXT	nvarchar(max)	IN
@JOBID	int	INOUT

Definition

Copy



CREATE procedure dbo.USP_EMAILJOB_ADDCONDITIONALJOB
(
    @PARENTJOB int,
    @JOBKEY nvarchar(1000),
    @NAME nvarchar(50),
    @CONTENTHTML nvarchar(max),
    @CONTENTTEXT nvarchar(max),
    @JOBID int output
)
as
begin

    insert into dbo.EmailJob(EmailID, Name, OwnerID, GUID, CreateDate, ContentHTML, ContentTEXT, FromAddress, FromDisplayName, [Subject], Priority, ReplyAddress, ReturnReceipt, ReturnReceiptAddress, ForwardDSN, ForwardDSNAddress, XMLDataSetAddressees, Status, SendAfterDate, EmailTemplateID, [Current], ClientIP, ConditionalParentJobID)
    select EJ.EmailID, @NAME, EJ.OwnerID, NEWID(), EJ.CreateDate, @CONTENTHTML, @CONTENTTEXT, EJ.FromAddress, EJ.FromDisplayName, EJ.[Subject], EJ.Priority, EJ.ReplyAddress, EJ.ReturnReceipt, EJ.ReturnReceiptAddress, EJ.ForwardDSN, EJ.ForwardDSNAddress, NULL, 4, EJ.SendAfterDate, EJ.EmailTemplateID, EJ.[Current], EJ.ClientIP, EJ.ID from dbo.EMAILJOB EJ
    where ID = @PARENTJOB

    select @JOBID = CAST(@@Identity as integer)

    update dbo.EMAILJOB_RECIPIENT
    set EMAILJOBID = @JOBID
    from dbo.EMAILJOB_RECIPIENT EJR
    inner join dbo.CONDITIONALCONTENTRECIPIENT C on C.ID = EJR.MERGEID    
    where EJR.EMAILJOBID = @PARENTJOB and C.JOBKEY = @JOBKEY

end