SQL Server Agent

I downloaded SQL Server 2012 and installed Evaluation with full option but I can't find SQL Server Agent.

Should I download it separately?

June 29th, 2015 5:02am

What edition you installed? Express or some other?

Did you check agent component in the list while running the wizard

Free Windows Admin Tool Kit Click here and download it now
June 29th, 2015 5:43am

Hello - It is quite likely that you installed SQL Server 2012 Express edition in which case SQL Server Agent does not get installed. SQL Server Agent is not a part of SQL Server 2012 Express or Express edition with Advanced services.

You need to execute the following query to confirm this (See the edition information displayed by this query):

SELECT ServerProperty('Edition')

Alternative/Other Solutions:

  • Put your script/ code in a script file and
  • Invoke the batch file using SQLCMD utility, such as sqlcmd -i script.sql, where script.sql contains T-SQL commands that you need to call
  • Call this batch file using Windows Scheduler

Hope this helps !


June 29th, 2015 6:48am

For Express Edition there will be NO SQL agent.

If the version is other than express. Go to SQL Configuration and start SQL agent manually

Free Windows Admin Tool Kit Click here and download it now
June 29th, 2015 10:16am

You asked the exact same question 5 days ago.  The answer is unlikely to change.
June 29th, 2015 10:28am

It's not Express version.

I downloaded standard version from here

I selected full options when I installed it.

Free Windows Admin Tool Kit Click here and download it now
June 29th, 2015 11:52am

What is the output of SELECT ServerProperty('Edition')?
June 29th, 2015 11:58am

Try repairing or re-installing.

You installation might have corrupted agent. From your link I can see that you have not installed express edition. 

 
Free Windows Admin Tool Kit Click here and download it now
June 29th, 2015 12:10pm

The output of SELECT ServerProperty('Edition'is 

Enterprise Evaluation Edition (64-bit)


  • Edited by Jeff0803 4 hours 28 minutes ago
June 29th, 2015 11:17pm

Hi Jeff0803,

Is the SQL Server instance installed successfully on your computer?  Please repair the SQL Server instance as other post and then show the screenshot of SQL Server Services node in SQL Server Configuration Manager.

Thanks,
Lydia Zhang

Free Windows Admin Tool Kit Click here and download it now
June 30th, 2015 3:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics