UFN_CMSUSERIMPORT_LOOKAHEAD

Returns whether there is a pending user import to run.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@BUSINESSPROCESSPARAMETERSETID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_CMSUSERIMPORT_LOOKAHEAD
(
    @BUSINESSPROCESSPARAMETERSETID uniqueidentifier = null
)
returns bit
as begin
    declare @NEXTID as int = 0;
    declare @NOW datetime = GETUTCDATE();
    exec @NEXTID = dbo.fnGetNextImportToProcess @NOW;    
    if @NEXTID > 0
        return 1;

    return 0;
end