共用方式為


RemoveJobByID Method

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

The RemoveJobByID method drops the SQL Server Agent job identified and removes the referencing Job object from the Jobs collection.

語法

object
.RemoveJobByID(
JobID
)

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • JobID
    String representation of the system-generated, globally unique identifier for a job.

Prototype (C/C++)

HRESULT RemoveJobByID(
SQLDMO_LPCSTR NewVal);

備註

For SQL Server Agent, a job identifier is a 32-byte string representing a hexadecimal number.

The RemoveJobByID method completely removes a job. When a multiserver administration job is targeted on the master server, the master server posts job-delete instructions to each execution target server. The indicated job is deleted at the master server immediately. Each target server deletes its local copy of the job when it next successfully polls the master server and retrieves the delete instruction.

ms134038.note(zh-tw,SQL.90).gif附註:
Removing a SQL Server Agent job by using the RemoveJobByID method requires appropriate permission. The Microsoft SQL Server login used for SQLServer object connection must be the owner of the job indicated by the JobID argument or a member of a role with greater privilege.

Applies To:

JobServer Object