Using SQL Server Management Studio
To add a SQL login or msdb role to a SQL Server Agent fixed database role
- In Object Explorer, expand a server.
- Expand Security, and then expand Logins.
- Right-click the login you wish to add to a SQL Server Agent fixed database role, and select Properties.
- On the User Mapping page of the Login Properties dialog box, select the row containing msdb.
- Under Database role membership for: msdb, check the appropriate SQL Server Agent fixed database role.
To configure a proxy account to create and manage SQL Server Agent job steps
- In Object Explorer, expand a server.
- Expand SQL Server Agent.
- Right-click Proxies and select New Proxy.
- On the General page of the New Proxy Account dialog, specify the proxy name, credential name, and description for the new proxy. Note that you must create a credential first before creating a SQL Server Agent proxy. For more information about creating a credential, see Create a Credential and CREATE CREDENTIAL (Transact-SQL).
- Check the appropriate subsystems for this proxy.
- On the Principals page, add or remove logins or roles to grant or remove access to the proxy account.
No comments:
Post a Comment