UFN_ETLHISTORY_GETLASTDATAWINDOWCLOSE
Returns the last data window close date for a given OLAP data source's refresh history.
Return
| Return Type |
|---|
| datetime |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @OLAPDATASOURCEID | uniqueidentifier | IN | |
| @INCLUDECHILDREN | bit | IN |
Definition
Copy
create function dbo.UFN_ETLHISTORY_GETLASTDATAWINDOWCLOSE(@OLAPDATASOURCEID uniqueidentifier, @INCLUDECHILDREN bit)
returns datetime
with execute as caller
as begin
declare @RETURNVALUE datetime;
select @RETURNVALUE = max(ETLHISTORY.DATAWINDOWCLOSE)
from dbo.ETLHISTORY
where ETLHISTORY.OLAPDATASOURCEID = @OLAPDATASOURCEID
and (@INCLUDECHILDREN = 1 or ETLHISTORY.ISPARENT = 1);
return @RETURNVALUE;
end