StartMonitor Method
The StartMonitor method begins monitoring of the local Microsoft® SQLServerAgent service by an instance of Microsoft® SQL Server™ 2000.
Applies To
| JobServer Object |
Syntax
object.StartMonitor( NetSendAddress , RetryAttempts )
Parts
object
Expression that evaluates to an object in the Applies To list.
NetSendAddress
String that specifies a network user by workstation address as described in Remarks.
RetryAttempts
Positive long integer that specifies a number of attempts made to restart SQLServerAgent service. When 0, no attempt is made to restart a stopped SQLServerAgent service job.
Prototype (C/C++)
HRESULT StartMonitor(
SQLDMO_LPCSTR szNetSendAddress,
long lRestartAttempts);
Remarks
With an instance of SQL Server version 7.0, an instance of SQL Server can monitor the locally installed SQLServerAgent service.
When monitoring of SQLServerAgent service is enabled and abnormal termination is detected, the SQLServerAgent service:
- Sends notification of SQLServerAgent service failure to the network user identified in the NetSendAddress argument, by network pop-up message.
- Attempts to restart the SQLServerAgent service as directed.