sql-server – 无法在SSMS中找到服务器代理

发布时间：2021-01-14 05:17:19 所属栏目：MsSql教程来源：网络整理

导读：我正在按照指南 – http://www.sqlchicken.com/2009/07/how-to-create-a-server-side-trace-with-sql-profiler/工作,直到我到达第8步 Now to schedule your newly created script. In SSMS connect to the server you want to trace on. Go to your SQL Serve

我正在按照指南 – http://www.sqlchicken.com/2009/07/how-to-create-a-server-side-trace-with-sql-profiler/工作,直到我到达第8步

Now to schedule your newly created script. In SSMS connect to the server you want to trace on. Go to your SQL Server Agent and expand it so you can see the Jobs folder. Right-click the Jobs folder and select New Job.

我找不到SQL Server Agent.我在哪里可以看到这个SQL Server代理？我已经为当前用户授予了所有访问权限.

解决方法

如果您未获得所需的权限,则无论您是否运行Enterprise / Standard / Datacenter等,您都将无法看到代理…

所需的角色是sysadmin,或者这里的各个角色 – http://msdn.microsoft.com/en-us/library/ms188283.aspx

（编辑：荆州站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!