USP_OLAP_DATASOURCE_ETLREFRESHTIME_KPIVALUE
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @VALUE | int | INOUT | |
| @ASOFDATE | datetime | IN | |
| @OLAPDATASOURCEID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_OLAP_DATASOURCE_ETLREFRESHTIME_KPIVALUE
@VALUE int output,
@ASOFDATE datetime,
@OLAPDATASOURCEID uniqueidentifier
as
set nocount on;
declare @LASTETLHISTORYID uniqueidentifier;
select
TOP 1 @LASTETLHISTORYID=ID
from
dbo.ETLHISTORY
where
COMPLETED=1 AND ISPARENT=1
AND OLAPDATASOURCEID=@OLAPDATASOURCEID
AND ETLENDTIME<=@ASOFDATE
ORDER BY ETLENDTIME DESC;
SELECT @VALUE=datediff(MINUTE,ETLSTARTTIME,ETLENDTIME)
FROM DBO.ETLHISTORY WHERE ID=@LASTETLHISTORYID;