Condividi tramite


ApplyToTargetServer Method

Questa funzionalità verrà rimossa in una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.

The ApplyToTargetServer method adds an execution target to the list of targets maintained for the referenced Microsoft SQL Server Agent job.

Sintassi

object
.ApplyToTargetServer(
str
)

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • str
    String that specifies, by name, an instance of Microsoft SQL Server.

Prototype (C/C++)

HRESULT ApplyToTargetServer(SQLDMO_LPCSTR NewValue);

Osservazioni

Before a SQL Server Agent job can execute, the job must have at least one step and an execution target.

When using SQL Distributed Management Objects (SQL-DMO) to create, schedule, and run SQL Server Agent jobs, use either the ApplyToTargetServer or ApplyToTargetServerGroup method to add an execution target. When a job will run on the server running SQL Server Agent, use the ApplyToTargetServer method to target the job, which specifies the server using the string (local).

Applies to:

Job Object