NuRoN Consulting, INC.

File Download
Donate for FREE Code
SQL Tools
- Databases
- Template Scripts

Blog > SQL Tools > Databases > Util > Procedures > dbo.usp_SqlAgentPoll_Cleanup

Dependencies for Stored procedure: Util.dbo.usp_SqlAgentPoll_Cleanup

ReferencingFQN	ReferencingType	ReferencedFQN	ReferencedType	Depth	RedHierarchy
Util.dbo.usp_SqlAgentPoll_Cleanup	Stored procedure	Util.dbo.SqlAgentPoll	Table	1	[Util].[dbo].[SqlAgentPoll]

Stored procedure: Util.dbo.usp_SqlAgentPoll_Cleanup

CREATE PROCEDURE usp_SqlAgentPoll_Cleanup
    @NumberOfDays INT = 365
AS
SET NOCOUNT ON
DELETE  dbo.SqlAgentPoll
WHERE   PollDateTime < DATEADD(DAY, -1 * @NumberOfDays, GETDATE())

Description for Stored procedure: Util.dbo.usp_SqlAgentPoll_Cleanup

Todo