Share via

RemoveJobsByLogin Method

  • 아티클

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The RemoveJobsByLogin method drops all SQL Server Agent jobs owned by the login identified and removes the referencing Job objects from the Jobs collection.

구문

object
.RemoveJobsByLogin(
Login
)

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • Login
    String that identifies a Microsoft SQL Server login by name.

Prototype (C/C++)

HRESULT RemoveJobsByLogin(
SQLDMO_LPCSTR szLogin);

주의

By default, any SQL Server login has membership, through the user guest, in the public role of the system database maintaining SQL Server Agent jobs (msdb). When a SQL Server user is created in msdb, jobs created by the user mapping the login are owned by the login, not the user.

[!참고] Removing SQL Server Agent jobs by using the RemoveJobsByLogin method requires appropriate privilege. The SQL Server login used for SQLServer object connection must be the login indicated in the Login argument and having a job ownership privilege or a member of a role with greater permission.

Applies To:

JobServer Object