Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2008 Express Edition Server Agent won't start Expand / Collapse
Author
Message
Posted Sunday, July 7, 2013 5:44 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 11:44 AM
Points: 124, Visits: 103
I can't get Server Agent to 'start' on my install of Express Edition. I did some research and it seems that server agent is not 'supported' or part of the software?

Does that seem correct? How would a DBA setup a backup job in this environment?

Any feedback would be appreciated........
Post #1471002
Posted Monday, July 8, 2013 1:53 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 2:17 PM
Points: 710, Visits: 1,455
It is not so much that the agent is not supported, the functionality is not actually present in the express editions.

Features Supported by the Editions of SQL Server 2008 R2

If you need to schedule a job you will need to setup a scheduled task that runs a SQL script via a utility like SQLCMD or PowerShell.


Joie Andrew
"Since 1982"
Post #1471071
Posted Monday, July 8, 2013 1:55 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, December 19, 2014 10:40 AM
Points: 2,480, Visits: 3,023
Allthough the SQL Agent service is installed with SQL Express, it is not possible to start it. The SQL Express version doesn't include (a working) SQL Agent.
If you want to perform scheduled tasks, like backups, you will need to create a SQLCMD command to do it and schedule this command using the Windows Scheduler.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1471072
Posted Monday, July 8, 2013 2:43 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 11:44 AM
Points: 124, Visits: 103
Thanks for the replies. This forum never disappoints.......
Post #1471371
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse