RemoveJobsByLogin Method
The RemoveJobsByLogin method drops all SQLServerAgent jobs owned by the login identified and removes the referencing Job objects from the Jobs collection.
Applies To
| JobServer Object |
Syntax
object.RemoveJobsByLogin( Login )
Parts
object
Expression that evaluates to an object in the Applies To list.
Login
String that identifies a Microsoft® SQL Server™ 2000 login by name.
Prototype (C/C++)
HRESULT RemoveJobsByLogin(
SQLDMO_LPCSTR szLogin);
Remarks
By default, any SQL Server login has membership, through the user guest, in the public role of the system database maintaining SQLServerAgent 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.
Note Removing SQLServerAgent 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.