共用方式為


StartMonitor Method

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The StartMonitor method begins monitoring of the local Microsoft SQL Server Agent service by an instance of Microsoft SQL Server.

語法

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 SQL Server Agent service. When 0, no attempt is made to restart a stopped SQL Server Agent service job.

Prototype (C/C++)

HRESULT StartMonitor(
SQLDMO_LPCSTR szNetSendAddress,
long lRestartAttempts);

備註

With an instance of SQL Server version 7.0, an instance of SQL Server can monitor the locally installed SQL Server Agent service.

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

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

Applies To:

JobServer Object