sys.sp_dbmmonitordropmonitoring

Description

Stops and deletes the mirroring monitor job for all the databases on the server instance. fixed server role, or execute permission directly on this The following example drops database mirroring monitoring on all of the mirrored databases

Syntax

sp_dbmmonitordropmonitoring
[ ; ]

Examples

Example 1

sp_dbmmonitordropmonitoring
[ ; ]

Example 2

EXECUTE sp_dbmmonitordropmonitoring;