Partager via


ApplyToTargetServer Method

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

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

Syntaxe

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);

Notes

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: