USP_DATALIST_OLAPDATASOURCE_ETLHISTORY
Returns the ETLHISTORY for the data mart ETL process.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONTEXTID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
| @INCLUDECHILDPACKAGES | bit | IN | Include child packages |
| @SSISPACKAGENAME | nvarchar(255) | IN | Package name |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_OLAPDATASOURCE_ETLHISTORY
@CONTEXTID uniqueidentifier,
@INCLUDECHILDPACKAGES bit=0,
@SSISPACKAGENAME nvarchar(255)=''
as
set nocount on;
if @SSISPACKAGENAME is null
set @SSISPACKAGENAME='';
else
set @SSISPACKAGENAME=@SSISPACKAGENAME + '%';
SELECT TOP 356
ID,
ETLSTARTTIME,
ETLENDTIME,
COMPLETED,
DATEDIFF(MINUTE,ETLSTARTTIME,ETLENDTIME) AS TOTALMINUTES,
ETLCONTROLID,
DATAWINDOWOPEN,
DATAWINDOWCLOSE,
SSISPACKAGENAME,
SSISMACHINENAME,
SSISUSERNAME,
SSISEXECUTIONINSTANCEGUID,
COALESCE(ETLENDTIME,GETDATE()) AS RSSPUBDATE,
ISPARENT
from dbo.ETLHISTORY
where OLAPDATASOURCEID = @CONTEXTID
AND ( (ISPARENT = 1) OR (@INCLUDECHILDPACKAGES = 1) )
AND ((@SSISPACKAGENAME='') OR (SSISPACKAGENAME LIKE @SSISPACKAGENAME) )
ORDER BY ETLSTARTTIME DESC, ETLCONTROLID DESC;