CREATE PROCEDURE [dbo].[CleanExpiredServerParameters]
@ParametersCleaned INT OUTPUT
AS
  DECLARE @now as DATETIME
  SET @now = GETDATE()
DELETE FROM [dbo].[ServerParametersInstance]
WHERE ServerParametersID IN
(  SELECT TOP 20 ServerParametersID FROM [dbo].[ServerParametersInstance]
  WHERE Expiration < @now
)
SET @ParametersCleaned = @@ROWCOUNT


GO
GRANT EXECUTE ON  [dbo].[CleanExpiredServerParameters] TO [RSExecRole]
GO