Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

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.

enter image description here

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.

share|improve this question
1  
You may want to add the version and edition of SQL Server you are using. –  Max Vernon Oct 1 '12 at 6:00
    
add comment

4 Answers

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

share|improve this answer
add comment

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

share|improve this answer
    
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
    
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. –  Max 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
show 1 more comment

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.

share|improve this answer
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
add comment
up vote 0 down vote accepted

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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