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 can not start Sql Server agent to create job. Can anyone help me? . I'm using Windows 7 Ultimate , Sql server 2008 Rc2

See this images:

enter image description here

enter image description here

share|improve this question

migrated from stackoverflow.com Sep 21 '12 at 7:53

This question came from our site for professional and enthusiast programmers.

    
Voting for migration to serverfault.com Besides, you might want to start by reading the message and follow the instruction. Check the event log and if that does not help you, post relevant entries here. –  Albin Sunnanbo Sep 21 '12 at 4:12
    
Thanks , i'll try right now –  user1687729 Sep 21 '12 at 5:14
    
Rc2? As in a release candidate of the original 2008? Or do you mean R2? –  Damien_The_Unbeliever Sep 21 '12 at 6:35
    
What information is logged to the Event Log when you try to start the service? –  Mr.Brownstone Sep 21 '12 at 8:12

2 Answers 2

SQL Server Express Edition does not include SQL Agent functionality.

While the installer does register the service entry, the service will fail to start if you try. (I verified with one of my own instances -- the error message I got is exactly the same.)

See this MSDN article for a comparison of features available in each edition of SQL Server 2008 R2.

If it's appropriate for what you need to accomplish, you can use the Windows Task Scheduler instead.

share|improve this answer

If you upgraded your SQL Server instance from SQL Server Express, this link might explain and solve your problem:

http://support.microsoft.com/kb/955763

"The SQL Server Agent service does not start after you upgrade from SQL Server 2008 Express or from SQL Server 2008 Express with Advanced Services to SQL Server 2008 Developer, to SQL Server 2008 Enterprise, or to SQL Server 2008 Standard"

share|improve this answer

Your Answer

 
discard

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