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

  1. 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 -> 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.

  • 2
    You may want to add the version and edition of SQL Server you are using. – Hannah Vernon Oct 1 '12 at 6:00
  • I know this is an old post... But also remember, that if SQL Server Agent is disabled in Services... You also won't see it in management studio. – user45047 Aug 5 '14 at 19:04

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 the individual roles here - http://msdn.microsoft.com/en-us/library/ms188283.aspx


SQL Server Agent is only available with certain versions of SQL Server. For instance, it is not available at all with SQL Server Express.

If you have SQL Server Standard or Enterprise it will be available in SQL Server Management Studio (SSMS) at the bottom of the listing of server items.

enter image description here

  • Actually I installed the SQL Server Enterprise Edition. I have not installed the SQL Server Express since I do not have the CD. So, how can I get the SQL Server Agent visible? – Jack Oct 1 '12 at 6:02
  • Could it be that I install SQL Server 2008 Enterprise on a Windows Server 2008 R2 cause such problem? – Jack Oct 1 '12 at 6:03
  • 1
    It should be automatically in SSMS, assuming it is installed. Did you choose to install SQL Server Agent during installation of SQL Server? Running on Windows Server 2008 R2 is not the problem. – Hannah Vernon Oct 1 '12 at 6:06
  • 2
    You also have to make sure that you are not using the Express version of SSMS, and that you have sysadmin rights to the instance, or the proper roles in the msdb database. – Jason Cumberland Oct 1 '12 at 16:52
  • 1
    Um, PowerShell seems like a solution looking for a problem. This still works in SQL Server 2012. mssqltips.com/sqlservertip/1272/… Sorry, unrelated to this answer. – Aaron Bertrand Mar 26 '13 at 16:07

Thanks Boris Hristov and Max Vernon for enlighten me.

Yes, to see the MSSQLSERVER, the user need to have the sysadmin permission. Also, if the MSSQLSERVER is the default instance for the SQL Server 2008, one will just need to call upon the Hostname and they will be able to see the SQL Server Agent.


You don't need SQL Server agent to start a server side trace. That is just to schedule it.

You can issue the commands directly in a management studio / query analyzer window.

Here is how:

Open SQL Server Profiler and setup the trace that you are interested in. Run the trace, then stop it. Go to File-->Export-->Trace Definition and select the target you are interested in.

This will save the SQL commands needed to start the trace in SQL Management Studio.

I use this technique all the time.

  • 1
    is it possible to explain further on how you issue the commands directly in a query analyzer windows? – Jack Oct 4 '12 at 5:36

I know it's old and already resolved but I encountered the issue and come across this page so maybe it will help someone.

In some cases your SQL Server Agent is not expandable with a label (Agent XPs disabled). In this case run this code to enable it.

sp_configure 'show advanced options', 1;  
sp_configure 'Agent XPs', 1;  

Here's the information related to this action.


Go to connection properties -- type msdb instead of default under options > connection properties > Connect to Database > msdb -- then connect

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.