NuRoN Consulting, INC.

Blog > SQL Tools > Databases > master > Procedures > sp_FailedJobs

Dependencies for System Stored Procedure: master.dbo.sp_FailedJobs

ReferencingFQN	ReferencingType	ReferencedFQN	ReferencedType	Depth	RedHierarchy
master.dbo.sp_FailedJobs	Stored procedure	msdb.dbo.usp_FailedJobs	Stored procedure	1	[msdb].[dbo].[usp_FailedJobs]
msdb.dbo.usp_FailedJobs	Stored procedure	msdb.dbo.sysjobhistory	Table	2	[msdb].[dbo].[usp_FailedJobs], [msdb].[dbo].[sysjobhistory]
msdb.dbo.usp_FailedJobs	Stored procedure	msdb.dbo.sysjobs	Table	2	[msdb].[dbo].[usp_FailedJobs], [msdb].[dbo].[sysjobs]
msdb.dbo.usp_FailedJobs	Stored procedure	Util.dbo.ParseDelimited	SQL inline table-valued function	2	[msdb].[dbo].[usp_FailedJobs], [Util].[dbo].[ParseDelimited]
msdb.dbo.usp_FailedJobs	Stored procedure	Util.dbo.StringConcat	Aggregate function (CLR)	2	[msdb].[dbo].[usp_FailedJobs], [Util].[dbo].[StringConcat]
Util.dbo.ParseDelimited	SQL inline table-valued function	Util.dbo.ParseDelimited_CLR	Assembly (CLR) table-valued function	3	[msdb].[dbo].[usp_FailedJobs], [Util].[dbo].[ParseDelimited], [Util].[dbo].[ParseDelimited_CLR]
Util.dbo.StringConcat	Aggregate function (CLR)	Util.UtilClr	ASSEMBLY	3	[msdb].[dbo].[usp_FailedJobs], [Util].[dbo].[StringConcat], [Util].[UtilClr]

System Stored Procedure: master.dbo.sp_FailedJobs

USE master
GO
IF OBJECT_ID('sp_FailedJobs') IS NULL EXEC ('CREATE PROCEDURE sp_FailedJobs AS SELECT 1 AS ID')
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

Description for System Stored Procedure: master.dbo.sp_FailedJobs

Todo