-- Stored Procedure: dbo.purge_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].[purge_agent_job_log]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[purge_agent_job_log]
GO




create procedure dbo.purge_agent_job_log 
as
/*******************************************************************************************************
*	dbo.purge_agent_job_log 
*	Creator: Bill Wunder	
*	Date: 	4-17-2002
*	Project:	
*	Project Mgr:	
*	Dev Contact:	
*	Outline:	
*			
*			
*			
*	How it Works:	
*			
*	usage:		EXECUTE admin.dbo.purge_agent_job_log 
*	Notes:		
*			
*	Modifications   
*                       
********************************************************************************************************/
delete admin.dbo.agent_job_log 
where RecCreatedDt < getdate() - 30




GO
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO