/****** Object:  Stored Procedure dbo.tng_add_pollset    Script Date: 12/1/2005 11:49:42 PM ******/

CREATE procedure dbo.tng_add_pollset
                (@name varchar(20), @Pinterval int,
                 @TOinterval int, @retries int,
                 @port_number int =161,
                 @getCommunityString  varchar(30) ='public',
                 @setCommunityString  varchar(30) ='admin',
                 @retriesInterval int =0,
                 @objectFilter  varchar(30) ='*',
                 @hostFilter    varchar(30) ='*'
)
as
     insert into dbo.tng_pollset ( name, interval, timeout, retries, port_number,
                               getcommunitystring,setcommunitystring,retriesinterval,objectfilter,hostfilter)
                 values  ( @name,@Pinterval, @TOinterval,@retries,@port_number,
                           @getCommunityString,@setCommunityString,@retriesInterval,@objectFilter,@hostFilter )
GO
GRANT EXECUTE ON  [dbo].[tng_add_pollset] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[tng_add_pollset] TO [wvadmin]
GO