-- Stored Procedure: dbo.show_agent_job_log
-- Bill Wunder

use admin
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON 
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[show_agent_job_log]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[show_agent_job_log]
GO


create proc dbo.show_agent_job_log
as
select id, cast(recCreatedDt as varchar(21)) [Date], cast(job_name + '.' + step_name as varchar(60)) as [job.step], message  from admin.dbo.agent_job_log where recCreatedDt > getdate() - 1.5


GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON 
GO