UFN_OLAPDATASOURCE_GET_AFTER_ETL_QUEUEPROCESSID

Returns the ID of a Queue Process parameter set for a queue that should run AFTER the ETL for this data mart.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@OLAPDATASOURCEID uniqueidentifier IN

Definition

Copy

CREATE function dbo.UFN_OLAPDATASOURCE_GET_AFTER_ETL_QUEUEPROCESSID(@OLAPDATASOURCEID uniqueidentifier)
returns uniqueidentifier

/*
Returns the ID of a Queue Process parameter set for a queue that should run AFTER the ETL for this data mart.
*/

as begin

    declare @QID uniqueidentifier;

    select @QID = AFTER_ETL_QUEUEPROCESSID from dbo.OLAPDATASOURCE WHERE ID = @OLAPDATASOURCEID;    

    return @QID;

end