USE [master]
GO
IF OBJECT_ID('dbo.sp_FailedJobs') IS NULL
EXEC ('CREATE PROCEDURE dbo.sp_FailedJobs AS SELECT 1 AS ID')
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE dbo.sp_FailedJobs
@Summary BIT = 1,
@JobNameLike VARCHAR(256) = NULL, -- 'Diablo.DataLoad.LoadInitial 04'
@StepNameLike VARCHAR(256) = NULL, -- 'LoadInitial'
@DaysBefore TINYINT = 7,
@FilterLineLike VARCHAR(1000) = NULL --' Description: An error occurred while processing file "%" on data row %.'
AS
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
DECLARE
@ReturnVal INT
EXEC @ReturnVal = msdb.dbo.usp_FailedJobs
@Summary = @Summary,
@JobNameLike = @JobNameLike,
@StepNameLike = @StepNameLike,
@DaysBefore = @DaysBefore,
@FilterLineLike = @FilterLineLike
RETURN @ReturnVal
GO
EXEC sys.sp_ms_marksystemobject sp_FailedJobs
GO