UFN_CMS_MIGRATEANONYMOUSEMAILUSERS_LOOKAHEAD
Determines whether or not the anonymous subscribers migration business process should run.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BUSINESSPROCESSPARAMETERSETID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_CMS_MIGRATEANONYMOUSEMAILUSERS_LOOKAHEAD
(
@BUSINESSPROCESSPARAMETERSETID uniqueidentifier = null
)
returns bit
with execute as caller
as begin
declare @SHOULDRUN bit = 0
select @SHOULDRUN=1 where exists(select distinct AES.ID from ANONYMOUSEMAILSUBSCRIBER AES
inner join EMAILADDRESS EA on AES.EMAILADDRESS=EA.EMAILADDRESS)
return @SHOULDRUN
end