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