StartMonitor Method (SQL-DMO)

The StartMonitor method begins monitoring of the local SQL Server Agent by the Microsoft® SQL Server™ installation.

object.StartMonitor( NetSendAddress , RetryAttempts )

Part	Description
object	Expression that evaluates to an object in the Applies To list.
NetSendAddress	String specifying a network user by workstation address as described in Remarks.
RetryAttempts	Positive long integer specifying a number of attempts made to restart SQL Server Agent. When 0, no attempt is made to restart a stopped SQL Server Agent service.

With SQL Server version 7.0, a SQL Server installation can monitor the locally installed SQL Server Agent service.

When monitoring of SQL Server Agent is enabled and abnormal termination has been detected, the SQL Server service:

Sends notification of SQL Server Agent failure to the network user identified in the NetSendAddress argument, by network popup message.
Attempts to restart the SQL Server Agent service as directed.

HRESULT StartMonitor(
SQLDMO_LPCSTR szNetSendAddress,
long lRestartAttempts);