sys.sp_dbmmonitorchangemonitoring

Description

Changes the value of a database mirroring monitoring parameter. Specifies the identifier of the parameter to be changed. Currently, only the following parameter is available: The number of minutes between updates to the database mirroring status table. The default Specifies the new value for the parameter that is being changed.

Syntax

sp_dbmmonitorchangemonitoring
[ @parameter_id = ] parameter_id
, [ @value = ] value
[ ; ]

Examples

Example 1

1

Example 2

EXECUTE sp_dbmmonitorchangemonitoring 1, 5;

Example 3

EXECUTE sp_dbmmonitordropmonitoring;

Example 4

EXECUTE sp_dbmmonitorhelpalert AdventureWorks2022;