USP_DATALIST_CONDITIONALCONTENTRECIPIENTJOBSPROCESSED
Returns the job IDs for each conditional email child of the specified job if the group is processed and ready to be sent.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EMAILJOBID | int | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
create procedure dbo.USP_DATALIST_CONDITIONALCONTENTRECIPIENTJOBSPROCESSED(@EMAILJOBID int)
as
set nocount on;
declare @C int
select @C = COUNT(1) from dbo.EmailJob EJ where EJ.ConditionalParentJobID = @EMAILJOBID and Status <> 12
if @C is null or @C = 0
select ID from dbo.EmailJob EJ where EJ.ConditionalParentJobID = @EMAILJOBID