未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。
The ApplyToTargetServer method adds an execution target to the list of targets maintained for the referenced Microsoft SQL Server Agent job.
語法
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);
備註
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).