UFN_EMAIL_GETPROCESSCOUNT
Returns the number of active processes for the specified type
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PROCESSTYPE | nvarchar(50) | IN |
Definition
Copy
create function dbo.UFN_EMAIL_GETPROCESSCOUNT(@PROCESSTYPE nvarchar(50))
returns integer
with execute as caller
as begin
declare @PROCESSCOUNT integer = 0;
set @PROCESSCOUNT = (select count(*) from dbo.EMAILPROCESSTRACKING where PROCESSTYPE = @PROCESSTYPE and ISACTIVE = 1);
return @PROCESSCOUNT;
end