Artikel von Frank

SELECT msdb.dbo.sysjobs.name, msdb.dbo.sysjobschedules.next_run_date, CASE (msdb.dbo.sysjobservers.last_run_outcome) WHEN 0 THEN ‚fehler‘ WHEN 1 THEN ‚Erfolg‘ WHEN 3 THEN ‚Abbruch‘ END AS STATUSTEXT, msdb.dbo.sysjobservers.last_run_date, msdb.dbo.sysjobservers.last_run_time, msdb.dbo.sysjobservers.last_run_duration, msdb.dbo.sysjobs.date_modified, CASE LEN(msdb.dbo.sysjobservers.last_run_duration) WHEN 6 THEN LEFT(CAST(msdb.dbo.sysjobservers.last_run_duration AS VARCHAR(6)),2) + ‚:‘ + […]

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[sp_sp_start_job_with_wait] ( @job_name SYSNAME, @WaitTime DATETIME = ’00:00:05′, — this is parameter for check frequency @JobCompletionStatus INT = null OUTPUT ) AS SET TRANSACTION ISOLATION […]

Update [DWH_Core].[dbo].[Dim_Bundesland] set [Wappen] =( SELECT ImageColumn FROM OPENROWSET(BULK N’E:\import\XXXXXWAPPEN.svg.png‘, SINGLE_BLOB) AS ImageSource(ImageColumn)) WHERE [DWH_ID] =21

USE [DWH_Meta] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF OBJECT_ID(‚dbo.[DW_ETL_Objects_detail]‘, ‚U‘) IS NOT NULL DROP TABLE dbo.[DW_ETL_Objects_detail]; CREATE TABLE [dbo].[DW_ETL_Objects_detail]( [TABLE_CATALOG] [nvarchar](120) NOT NULL, [TABLE_SCHEMA] [nvarchar](50) NOT NULL, [TABLE_NAME] [sysname] NOT NULL, […]

—für dieses Beispiel nehmen wir unsere Core Datenbank aus dem DWH und bauen uns eine Datumsdimension auf. USE [DWH_Core]; IF OBJECT_ID(‚dbo.[Dim_Date]‘, ‚U‘) IS NOT NULL DROP TABLE dbo.[Dim_Date]; CREATE TABLE [dbo].[Dim_Date]( [DateID] [int] NULL, [Date_DE] […]

—in unserem Beispiel nehmen wir unsere Stage Datenbank aus dem DWH SELECT * FROM [DWH_Stage].Information_Schema.Columns with (nolock)