|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | usp_ETLExecutionLog_MostRecentExecution |
| Schema | dbo |
| Is Encrypted | False |
| Ansi Nulls Status | True |
| Quoted Identifier Status | True |
| Description |
Parameters
| Name | Data Type | Direction | Description |
Parent Dependencies (objects that usp_ETLExecutionLog_MostRecentExecution depends on)
| Name | Type |
Table |
|
StoredProcedure |
Child Dependencies (objects that depend on usp_ETLExecutionLog_MostRecentExecution)
| Name | Type |
STOREDPROCEDURE |
|
TABLE |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: StoredProcedure [dbo].[usp_ETLExecutionLog_MostRecentExecution] Script Date: 03/09/2017 17:21:49 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON /* Name: Craig Love Date: 11/21/2013 Company: PragmaticWorks / HETGroup Project: EnterpriseDW Description: Provides information contained for the most recent ETL Execution Logs. */ CREATE PROCEDURE [dbo].[usp_ETLExecutionLog_MostRecentExecution] AS SET NOCOUNT ON DECLARE @MaxETLExecutionLogIdint SELECT @MaxETLExecutionLogId = MAX(ETLExecutionLogId) FROM dbo.ETLExecutionLog IF @MaxETLExecutionLogId IS NOT NULL EXEC [dbo].[usp_ETLExecutionLog_DetailReport] @ETLExecutionLogId = @MaxETLExecutionLogId ELSE PRINT 'No execution logs exist!!' |
| Powered by BI Documenter |
