patternsqlMajor
Could not find the Server Agent in SSMS
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
Jobs -> New Job">
I cannot not find
- 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)
Also, if the SQL Server Agent service is disabled or not running, you also won't see it in SQL Server Management Studio.
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.