HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMajor

Could not find the Server Agent in SSMS

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
thessmsagentcouldfindservernot

Problem

I am following the guide - http://www.sqlchicken.com/2009/07/how-to-create-a-server-side-trace-with-sql-profiler/ which is working until I reach Step 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.




Jobs -> New Job">

I cannot not find SQL Server Agent. Where can I make this SQL Server Agent visible? I have given the current user all the access permission.

Solution

If you are not granted the needed permissions, you will not be able to see the Agent, no matter whether you run Enterprise/Standard/Datacenter, etc...

The roles needed are sysadmin, or one of the individual roles listed in the article SQL Server Agent Fixed Database Roles (Microsoft | SQL Docs)

  • SQLAgentUserRole



  • SQLAgentReaderRole



  • SQLAgentOperatorRole



Also, if the SQL Server Agent service is disabled or not running, you also won't see it in SQL Server Management Studio.

Context

StackExchange Database Administrators Q#25192, answer score: 22

Revisions (0)

No revisions yet.