The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_dbmmonitorchangemonitoring(int @parameter_id, int @value)
MetaData:
create procedure sys.sp_dbmmonitorchangemonitoring ( @parameter_id int, -- There is only one parameter_id now. 1 = update period in minutes. @value int ) as begin set nocount on if (is_srvrolemember( N'sysadmin') <> 1 ) begin raiserror(21089, 16, 1) return 1 end declare @retcode int, @schedname nvarchar( 256 ) select @schedname = isnull( formatmessage( 32048 ), N'Database Mirroring Schedule' ) if (@parameter_id < 1 OR @parameter_id > 1) begin raiserror( 32036, 16, 1 ) return 1 end if (@parameter_id = 1) -- kind of a redundant check begin -- validate update_period to make sure that it is a reasonable number. 1-120 minutes for now. -- do not forget to keep this in synch with the add sp. if (@value < 1 or @value > 120) begin raiserror ( 32032, 16, 1, @value) -- specific message for the update period. return( 1 ) end exec @retcode = msdb.dbo.sp_update_schedule @name = @schedname, @freq_type = 4, -- Daily @freq_interval = 1, -- Every 1 days @freq_subday_type = 4, -- Based on Minutes @freq_subday_interval = @value -- interval end if ( @@error != 0 OR @retcode != 0 ) begin raiserror( 32035, 16, 1 ) return 1 end return 0 end
No comments:
Post a Comment